Conditional Show Sheet Not Equal Syntax

[#1]

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.

[Nicole-Smith]

What about:

if(OSUser()= 'usernamehere', 0, 1)

[#3]

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.

[#4]

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.

[#5]

Try

Not(osuser()='username')

[#6]

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')

[jagan · Accepted solution]

Hi,

Try this

=Not(Match(OSUser(), 'username1', 'username2'))

Regards,

Jagan.

[#8]

This solution works.  I'm testing it under some other circumstances.  Thanks for everyone's input.