Hierarchy wise sheet access.

[#1]

Hello everyone,

I need to provide access to sheets according to users in hierarchy.

For example:  CM>ZM>RM>SM>UM

SM should be able to access sheets of UM under it and so on.

Please help regarding the same.

Regards,

Utsav

[#2]

You can build an access table like this:

Then under Sheet Properties > General > Show Sheet > Conditional you can use something like [CM]=1 for the sheet CM and so on.

[#3]

HI rebeccad,

what condition should i use in the conditional field?? nothing seems to be working with this.

Regards,

Utsav

[#4]

Say you have your security table (like the one I put above) as a file in Excel.  Load it into your script.  The USER column should be a list of users (you can see yours if you type this into your text object: =OSUser()

Then put a 1 for the sheets each user should see.  Then in Sheet Properties > General > Show Sheet > Conditional, you will type [CM]=1.  Let me know if you are still confused.