Hiding Users Sheet

[Noor51]

Hello, 

I trying to hide sheet for some user. I use the formal =MixMatch(OSUser(),'XXXX') to hide the users, but I have to put everyone individual name in the expression or load script. 

I was wondering if I can be able to use custom properties department list for this instead of putting individual. 

Or is there a different function I have to use to use the department list. 

[Vegar · Accepted solution]

Take a look at SectionAccess. There you can use usernames or ad group to configure the access. 

Let the section access filter down on a data Island containing one value per sheet you want to configure. Use the Island values to define the show condition and the section access to limit which users that should be able to access which values.