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.
|