Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How can i easily hide sheets in my app without any conditions. I want to hide these as we dont want to currently make these available to users.
Thanks
Set the Show Sheet as Conditional and set to zero
Under Properties of the sheet, General, Conditional set it to 0 or 1=2 like Colin said, but i prefer for example to set it conditional that only you can view it, by using the OSUser() function.
for example set the condition to: if (OSUser() = 'MALEK.SAFA,1,0) that way you will be the only one that is able to see the sheet.
thanks. To show it again would I use the document properties?
can you give me an example of osuser pls
under sheet properties, go to conditional and type the below for example
=if(OSUser() = 'CORP\BIUSER',1,0)
if the user is 'CORP\BIUSER' then it will be able to see the sheet, OSUser() takes the user name that you are accessing with, so in my case CORP is the corporate active directory name and BIUSER is the user (in my case it is the windows authentication user).
you can easily identify your OSUser(), by simply creating a text object in the dashboard with the expession =OSUser()
Dear Bshindroja,
Easiest way to hide and show the sheet.
Hide Sheet:
Sheet Properties > Tab General > Select Radio Box "Conditional" set value 0 > Apply > OK.
Show Sheet:
Settings > Document Properties > Tab Sheets > Select "Sheet" > Properties > General > Select Radio Box Always > Apply > OK.
Kind regards,
Ishfaque Ahmed