Maco that prompts password entry based on pick list values

[kwp004]

Here's what I'm trying to accomplish:

• In cell A1 of Sheet1, I have data validation that requires the user to select from a pick list in Column B of Sheet 2.
• I have a button that runs a macro.
• If the user clicks the button, I want them to be prompted to enter a password based on the pick list selection, the corresponding value in Column B of Sheet 2, and an adjacent password in Column C of Sheet 2.
• If the password is correct, the macro runs. If it's incorrect, they get an error message.

So for example:

1. In Sheet 2, Range B1 = "Option 1". Range C1 = "Password 1"
2. In Sheet 2, Range B2 = "Option 2" Range C2 = "Password 2".

The user goes to A1 in Sheet 1, selects "Option 2" in the pick list. When they click a button to run a the macro, they need to enter "Password 2", or else they get an error message.

 

[kwp004]

Thank you.

How do I make a sheet very hidden again, once I navigate to another sheet?