Unprotecting a worksheet by username

[jwongsf]

HI All
I would like to unlock the work sheet based on the username.
However this code does not seems to be working,
I would appreciate any assistance with this

The object is that only these users have access to the locked cells on a sheet and those users not on the list would only have access to the unlocked cells.

Please Login or Register  to view this content.

Thank you for any assistance that you can offer.
James

[jasoncw]

The procedure you posted requires the users to have that exact name set up within Excel (under Tools > Options > General tab for Excel 2003). Are these set up in Excel? Or are you trying to capture their network user id?

[royUK]

This works for me

Please Login or Register  to view this content.

[DonkeyOte]

Just re-iterating the others

jasoncw's point is critical... anyone can change the Application.Username as outlined ... the NT id is of course (in theory) much more secure... if that's what you want to use (advised if in Network environment) then search:

Please Login or Register  to view this content.

and you should find plenty of info.

As outlined by Roy's code VBA unlike native XL is case-sensitive by default (Apple <> apple) so either :

a) coerce strings to common case when comparing

or

b) as Roy outlined - use

Please Login or Register  to view this content.

statement at head of the Module containing the code so as to make that Module case in-senstive (apple = Apple)