"From a front sheet that is the only visible sheet in a workbook, I'd like users to enter a password
and their sheet is unhidden automatically for them. There are many sheets so there needs to be
a way to list passwords and the sheets they unhide. Also, if the users could change their own password,
that would be best of all."
SPECIFICATIONS - ONE SHEET PER PASSWORD:
NOTE: Normally the VBA for a project like this is password protected, too. In the sample workbook above it is not protected. Be sure to password protect your code after you apply it to your own projects. If users can see the VBA and guess the name of your hidden "passwords" sheet, then there's no point to this. Name your actual passwords page something unlikely, like PWDHAMSTER199.
This code goes into a standard code module and is attached to a button to prompt for a password:
This code also goes into a standard code module, this handles the changing of passwords by users:
MORE SHEETS PER PASSWORD:
"I have a similar need as above, but I need to unhide more than one sheet per password. Also, I need to be able to navigate these sheets without them hiding again until I'm finished with them."
For this we do not use a ThisWorkbook macro to hide sheets, instead we put this in the main Front sheet's module to hide all the other sheets whenever we return to the Front sheet:
The Passwords page now lists passwords in column A, then as many sheetnames on the same row as you would like to unhide.
Lastly, this is the macro, stored in a standard code mudule then attached to a button (optional), to unhide the sheets: