Hidden Sheet

[#1]

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?

[ashfaq_haseeb]

Hi,

You can

Have a look at osuser() function.

Regards

ASHFAQ

[avinashelite]

Hi Tumelo,

Go to sheet properties and use conditional show.

use condition like if(role='Admin',1,0)

[amit_saini]

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

[tresesco · Accepted solution]

Right click on the sheet-> General tab->Show Sheet (Conditional)

Expression like: Osuser()='Peter'              // this will make the sheet available only to Peter

[#6]

Thanks a lot for the prompt response guys, you were all helpful.

This community is awesome!