Conditional Password

[subhs82]

I do not have any idea if what I want is at all possible. here is what I want.

I have a dropdown list from where I am to select months. Basis my selction I will be able to view some other data by means of vlookup. now, when I select a particular month (say october) I want the system to ask for a password to continue and display relevant data. The password would be asked only for that month, for the other months the vlookup would return relevant data.

Can anyone please help??

[tigeravatar]

subhs82,

What you're asking for would require VBA, which means in order to use the workbook properly, macros must be enabled. Attached is an example workbook based on the criteria you provided. When October is selected a userform pops up asking for a password (the default password is just "password" no quotes). It will not show the data unless the correct password is entered.

The month data is setup on a xlVeryHidden worksheet named 'Data'. xlVeryHidden means that you cannot unhide it outside of the Visual Basic Editor.

To access the Visual Basic Editor, use the keyboard shortcut ALT+F11. In there you can see the userform and all code used to perform the actions. Also, 'Sheet1' is password protected to prevent editing. The sheet protection password is just "123" no quotes.

[subhs82]

This is exactly the type I was looking for...THAAAAAAAANK YOU soooooooo much. Let my try and put this into the main file. If any trouble happens, will let you know, else will close this thread as resolved. Thank you once again.

[subhs82]

THANKS A TON Tigeravatar !!!! You made my day.