Drop down box with associated passwords
 

I have been trying to create a pull down list within excel to limit
what can be entered into a cell with protection.

What I am aiming for is a pull down list of peoples initials, once the
selection has been made a request for a password is made. This will
identify that the correct person is using their initials.

I have tried all variations with the basic Excel protections available
but this seems too complicated for any of them.

Thanks to any one that has an idea.

Drop down box with associated passwords
 

Comments inline

NickHK

"gall" wrote in message
ups.com...
I have been trying to create a pull down list within excel to limit
what can be entered into a cell with protection.
Data Validation ?

What I am aiming for is a pull down list of peoples initials, once the
selection has been made a request for a password is made. This will
identify that the correct person is using their initials.
Combobox filled with initial. _Change event, Input box for password, VLOOKUP
response against initials.

I have tried all variations with the basic Excel protections available
but this seems too complicated for any of them.
Not sure what you mean here, but if the above step is successful, then
MySheet.UnProtect "Password".


Thanks to any one that has an idea.