Password for drop down list

Hi

I able to create data validation drop down list etc. I want to assign passwords to different text strings (users) in the list. I have tried searching and found this thread on HERE. Its perfect for myself and confident i can update it as necessary.

I was hoping to make it more user friendly for other colleagues. I was hoping my validation list could be in separate file with usernames in row A and their passwords in row B. My intention would be the file with validation list would be password protected for only the boss to update.

Thanks in advance.

Thanks for reply. I'm able to do the list. But:

Please Login or Register  to view this content.

Is there a way of not having to manually input names and passwords into this code. Instead it will look at column A and B in the other file (where my validation list will be).

Thanks

Hi Leith Ross. Please excuse me if I just being dum. Its the password for each name in the validation list I want to achieve. Without having to manually put the passwords in the code above. There is a link to an example file in original post.

In code above, to select mike from the list you have to input Mike1 as password first. So instead of these lines

Const Mike As String = "Mike1". It will look at A1 for name B1 for password, A2 & B2 etc etc. My validation list code be from A1:A30 and corresponding passwords for those names would be in B1:B30

Thanks for reply. Very new to excel. Shall read up on how to achieve the above