Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a lookup of names :
OSUSER , ADMIN_LEVEL
ThisDomain\User1 , 1
ThisDomain\User2 , 1
ThisDomain\User3 , 2
Is there a way of hiding a tab or a button to all those users who are level 2?
Thanks
Phil
Yes, and the most straightforward implementation comes with Section Access.
See for example here:Sheets Security with Section Access
The article contains a link to another post that does the same thing using MATCH() calls. That may be simpeler to use if you don't need strictly controlled access or data reduction.