Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Have Qv Dashboard using around 200 users
Sheets before
A,B,C
recently we created new sheet D
A,B,C,D
for that new sheet we have to implement Security
for 100 users we have to show all the sheets(A,B,C,D)
remaining 100 users (A,B,C)
Please help
Thanks
You need to make use of section access to achieve this , check this
Just a simple idea (length of login name within domain must be identical😞
You need to create an access table somewhere.
ACCESS:
LOAD * inline [
GroupABC, GroupABCD
yourdomain\user1 , yourdomain\user2
yourdomain\user3 , yourdomain\user4
] ;
Then go to the properties page of each sheet:
For sheets A, B and C set the following condition:
=wildmatch(Upper(Concat(GroupABC)),'*'&Upper(OSUser())&'*')
For sheet D set:
=wildmatch(Upper(Concat(GroupABC)),'*'&Upper(OSUser())&'*')
or wildmatch(Upper(Concat(GroupABCD)),'*'&Upper(OSUser())&'*')
That's all. Using the Upper function ist optional.