Drop down list protected by individual passwords (VBA)

Hi everyone,

I have been scratching my head for a few hours now and I cannot figure this out on my own.

I want to create a drop down list, with 4 slots, first blank, and the 3 others are names, let's say Bob X, Lee Y and Steve T.

This is for manager approval. What I want is that no one can mess with this drop down list, except for those 3 Managers.

i.e. Bob want to click his name, he needs to input his specific password, if wrong, he will get a message "Wrong Password". If good, his name will be showing, proof of his approval. But his password won't work if he clicks Steve for example.

Thanks to anyone that can help me on this one.

What kind of "drop down list" are you using for this? Is it "in cell data validation" or one of the combobox controls? Is it on a userform or on a sheet?

Any chance of a small sample workbook so a solution can be tailor made?

BSB

Whilst we look into this for you, could you edit your post so there are code tags around your code? Forum rules and all that.

BSB

Forgot to answer a question, it's on a sheet, once done, I will password protect most of it, leaving some cells free, to input data

Thanks, I didn't know about this

One other thing. Excel is not a good tool to enforce security. If someone wants to bypass this, all they have to do is not allow macros to run.

Originally Posted by 6StringJazzer

This code won't compile. To use the strings you declared at the top, remove the "1" in the following lines. Then you will be correctly using the declared variables.

Beat me to it!

BSB

Thanks, I gave it a try and still the same, choosing any name, applying password, i.e. password Bob1 when choosing Bob, always get "Wrong Password"

Works fine for me.
Don't forget that the password will be case sensitive.

BSB

Works perfectly, Thanks a lot

Still have a question on this one, if I want to use complete names in the list, i.e. Bob Cooper, what modification will I have to make in the VBA?

Thanks again, very helpful

Alter the data validation list and then amend the case lines of code to match:

Please Login or Register  to view this content.

BSB

Fantastic, You solved this one within minutes, I spent hours trying to figure it out.

Thanks and have a great day

Only easy when you know how!

Jeff gets the credit though as he got in with the answer first

BSB