Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have 100 users who are accessing the application(QVW).
user1 has to access sheet1,sheet2
User2 has to access sheet3,sheet4,sheet5
user3 has to access sheet6, sheet7, sheet8 same way it goes till 100 users
How can we achieve this any idea?
Thanks in advance,
Madhu
This one as well. It is a thread about all security threads.
Hi Madhu,
you need to set the permissions in the Sheet properties. Go to Sheet1 -> Properties -> General -> Show Sheet -> Check on "Conditional" and then fill in the condition like this:
=mixmatch(osuser(),'domain\user1')
Do the same for Sheet2.
For Sheet3, Sheet4 and Sheet5:
=mixmatch(osuser(),'domain\user2')
And so on.
Hope this helps.
Hi PFA
Do you have any group of users who are using certain sheets or not?
Hi Madhu,
Did you able to resolve the issue?