Passwords
Put this code into a workbook open event
User = Environ("UserName")
select case User
Case "Joe"
'add code to unprotect a1
Case "Mary"
'add code to unprotect b1
Case "Steve"
'add code to unprotect c1
end select
"Still Learning" wrote:
Will that make it so when Joe logs in, he only has access to a1, Steve can
access b1 and Mary can access c1?
"Joel" wrote:
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
|