Sheet to be visible only to a group

[Anonymous]

Hi All,

My requirement is that one sheet in a dashboard should be visible only to a particular group. Please let me know how this can be done.

Thanks in advance

Anupama

[MK_QSL]

Go to the sheet properties

Under Show Sheet

In Conditional

Write below...

Group = 'A'

[#3]

Hi Anupama,

Yo can do an excel file for example defining a list of users with a group associated, load this file in the script and then do the following:

- In the sheet properties at the show condition you must set a condition based in group defined, and you can identify the current group user though OSUser() function that allow to know the user is logged.

You can use an excel as the following:

USER	GROUP
DOMAIN\user1	A
DOMAIN\user2	A
DOMAIN\user3	B
DOMAIN\user4	C
DOMAIN\user5	C

And then evaluate the user logged with OsUser() and compare it with USER field and then work with group field.

Tell me if you have any question.

Regards