Using an Admin Lookup to control access

[prees959]

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

[Peter_Cammaert]

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.