Get the environmental variable for the username usingg this code

User = Environ("UserName")

then you can have a list of users that the macro will automatically unprotect

"Still Learning" wrote:

I know how to protect certain cells so that different users can only access
what they are allowed, and I know how to password protect a sheet. How can I
combine the two so that when you use a password to open a workbook, it only
gives you access to what you are allowed.

Thanks ahead of time,
Chris