Password removal via VBA (as defined in the code with password)

[galvinpaddy]

Afternoon happy campers,

First off - This is not a request to bypass or break a password, i have the password and want to know how to modify my current code.

I have the following code in one of my sheets:

Please Login or Register  to view this content.

Which works fine, however, i want to add code to it that will look at the username, and if for example the user is 'Tom.Jones' then the code would only unlokc 'Sheet.3' and nnot the whole file.

Your help, as always is greatly appreciated.

[blue.chio]

perhaps something like this

Please Login or Register  to view this content.

[galvinpaddy]

Hi Blue,
Thans for the code, i will check shortly and feedback :D