I'm working on a password protected multi-sheet workbook and I want users to see the "Instructions" sheet, the "Week#" sheet, and their individual sheet only. The admin has her own password to be able to see all sheets. Each user has their own password assigned to them and can then see only the sheets designated for them.
My question: Is there a way to hide all the sheets (minus the Instructions sheet) upon opening? Once the user enters their password (PASS1, PASS2, etc.), they should be able to see their specified sheets (User1, User2, User3, User4, Week#, etc.). What's happening now is that all users are able to see all sheets until the user clicks 'Enable Content'.
Here's the code I'm currently using (you might be able to tell that I'm new to VBA):
Bookmarks