Adding an 'IF' to my current VBA

[galvinpaddy]

I have the following code in 'ThisWorkBook'

Please Login or Register  to view this content.

My question is how can i add another if, to allow it to check for 1, 2, 3 or more usernames?

Kind regards!

[Andrew-R]

Something like this, perhaps:

Please Login or Register  to view this content.

[:) Sixthsense :)]

I suggest you to keep a separate sheet called Users and in Column-A fill the User Names you would like to add.

Then change your below line

If Environ("USERNAME") = "user.name" Then

To

Please Login or Register  to view this content.

[galvinpaddy]

Thanks, both great solutions!!!