multiple If conditions

[anziga]

If I check system logon/username and do something like:

If UserName <> "johndoe" Then ActiveWorkbook.Close True

this works, but if I want to set more possible users, like:

If UserName <> "johndoe" Or If UserName <> "janedoe" Then ActiveWorkbook.Close

this doesn't work. Any idea what is the correct way to do this? Or is there any other way to set authorized users for the workbook, without user's input?

 

[rpaulson]

if its not johndoe OR not Janedoe would the result not always be true?

I think you might want an AND


I might be confusing myself here ?!?

 

[anziga]

Only johndoe or janedoe should be able to open/use the workbook, that is, if either one is the current system user.

 

[Michael M]

Try

If UserName <> "johndoe" Or UserName <> "janedoe" Then ActiveWorkbook.Close

 

[anziga]

Didn't work, tried earlier... but in actual VB it works, that's why I tried that first.

 

[Michael M]

Have you checked the syntax of "johndoe" and "janedoe" against what is entered in the system
Make sure there isn't a leading space or seperator.....or capitalisation in the names.

 

[anziga]

I double checked, but for some reason it just doesn't work. I did a test:

If UserName <> "johndoe" Then
If UserName <> "janedoe" Then ActiveWorkbook.Close True
End If

this works, if either one is logged in, document opens OK, but if the user is not either one, document will closes as it should do. But not sure how it works, if there are more authorized users, but in my case I only need two, so it's OK for now.