Hello. There are several discussions about that topic but I'm not able to get my whole idea working based on these (some really good) peaces of knowledge. So I decided to ask help here.
I am trying to have an excel workbook after opening to show only certain sheets for one user, some other sheets for second user and so on. This is not based on security need, but for convenience and to prevent accidental mistakes:
- On open the workbook should show only one sheet (Login sheet) and a userform for inserting the users password.
- This userform should check from the data set in another hidden worksheet, if the entered password is valid. This hidden sheet contains all users UserNames, Passwords and SheetNames (multiple sheets for each user), that are to be shown when the user enters his password.
- On closing all the sheets, except Login sheet, must get "very hidden" again.
Hope I made my wishes understandable.
Any help and guidance would be greatly appreciated. Thanks!
Bookmarks