Sheet Viewing Restriction for Certain Users

[roboto404]

I am attempting to create a workbook with some restricted access. The way I would like it is having the "Menu" worksheet having a dropdown list of names. When a user chooses their name, it prompts them for a password.

For example

Jane selects her name from the dropdown list, it prompts her for a password. She enters her password correctly and Sheet2 and Sheet5 only shows up for her.
John selects his name from the dropdown list, it prompts him for a password. He enters his password correctly and Sheet3 and Sheet6 only shows up for her.
Administrator selects Administrator from the dropdown list and it prompts them for a password, they type in their password and all sheets show up for them.

My supervisor asked for an alternate way of protecting a workbook. He didnt want the Administrator typing in a password for each sheet when they want to access it. Is this possible?

[PaulM100]

Try this code. It goes into the worksheet module of the master sheet:

Please Login or Register  to view this content.

and off course,you need to use your sheet names and dropdown. Also, you should protect your code with a password

[roboto404]

Try this code. It goes into the worksheet module of the master sheet:

Please Login or Register  to view this content.

and off course,you need to use your sheet names and dropdown. Also, you should protect your code with a password

Thank you very much for this! But I ran into this error after, did I do anything wrong?

error1.PNGerror2.PNG

[Melvosh]

Change "Dim pswd as String" to "Dim pwd as String"

[roboto404]

Change "Dim pswd as String" to "Dim pwd as String"

Awh embarrassing! Doh! Thank you!

[roboto404]

After saving, closing, and opening again, it looks like the workbook opens from the last logon instead of the default Login Worksheet, is there a way to open the workbook at the login sheet every time its opened?