Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am tasked to build a functionality that will only be used by the ADMIN Users. This functionality must be placed in a hidden sheet which I should only make available to ADMIN Users.
How do I make a sheet available to only specific Users?
Right click on the sheet-> General tab->Show Sheet (Conditional)
Expression like: Osuser()='Peter' // this will make the sheet available only to Peter
Hi,
You can
Have a look at osuser() function.
Regards
ASHFAQ
Hi Tumelo,
Go to sheet properties and use conditional show.
use condition like if(role='Admin',1,0)
Tumelo,
Please see the attachment.
Use Username : admin
Password: admin
Also please see the link below:
Re: OSUser(): Visible data restricted through user
Thanks,
AS
Right click on the sheet-> General tab->Show Sheet (Conditional)
Expression like: Osuser()='Peter' // this will make the sheet available only to Peter
Thanks a lot for the prompt response guys, you were all helpful.
This community is awesome!