Hi,
Try the attached workbook. When the workbook opens, only the 'User Guide' sheet is displayed. I added a 'Shape' in the 'User Guide' Sheet that requests the Secondary Password and Displays the appropriate sheets after the Secondary Password is entered. It is simple, and allows multiple retries.
I modified the routine to display or hide the Worksheets based on the Secondary Password (case insensitive):
'ADMIN' - Display all sheets
'SALES' - Display only sheets with green tabs (colorindex 43)
Otherwise - Display on sheet 'User Guide'
Lewis
ThisWorkbook code follows:
Ordinary Module 'ModDisplayOrHideSheets' code follows:
Bookmarks