Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the sheet properties, I am trying to set the Show Sheet/Conditional feature to prevent select users from viewing the sheet based on an expression. But my syntax is incorrect.
I know how to enable select users to view a sheet through sheet properties, using syntax such as this:
OSUser()= 'usernamehere'.
However, I'm trying to do the inverse - disable select users from viewing the sheet.
I've tried using the following the syntax combinations:
OSUser() <> 'usernamehere'
OSUser() -= 'usernamehere'
Neither of my not-equal expressions works. Would anyone know of a solution?
Other notes:
Under Settings/Document Properties/Security, I have the 'Show All Sheets and Objects' box not checked.
Under Settings/Document Properties/Sheets, the sheet I'm trying to hide has a status of Conditional: Normal.
Hi,
Try this
=Not(Match(OSUser(), 'username1', 'username2'))
Regards,
Jagan.
What about:
if(OSUser()= 'usernamehere', 0, 1)
Thanks, Nichole. I tried that approach, but my test user can still view the tab even with the following restriction.
if(OSUser()= 'usernamehere', 0, 1)
I keep wondering if there is a conflict with the Document Property Settings, but I don't see anything obvious.
Thanks, Nichole. I tried that approach, but my test user can still view the tab even with the following restriction.
if(OSUser()= 'usernamehere', 0, 1)
I keep wondering if there is a conflict with the Document Property Settings, but I don't see anything obvious.
Try
Not(osuser()='username')
Nigel, your proposal worked when I was trying to exclude a single user. But I have multiple users to exclude. Would you know the correct syntax when I'm excluding multiple users?
WORKS FOR SINGLE USER:
Not(OSUser()= 'username1'
FAILS FOR MULTIPLE USERS:
Not(OSUser()= 'username1' OR
Not(OSUser()= 'username2'
ALSO FAILED with this syntax:
Not(OSUser()= 'username1', 'username2')
Hi,
Try this
=Not(Match(OSUser(), 'username1', 'username2'))
Regards,
Jagan.
This solution works. I'm testing it under some other circumstances. Thanks for everyone's input.