Password Protecting Hidden Sheet

When you hide the sheet, it must be done with VBA and use the VeryHidden parameter, this way it cannot be manually unhidden, it can only be unhidden with VBA.

My favorite way is to use a Worksheet_Deactivate() event in the sheet module of for all the sheets I want to be well hidden. When you are on the sheet and the step away to another sheet, it hides itself:

Please Login or Register  to view this content.

This code is in the Sheet2 and Sheet3 modules of the attached workbook.

Then on sheet1 are some buttons for accessing those hidden sheets. This is a simple password check.

Please Login or Register  to view this content.

Just a tip, in your real-workbook, do not put the actual name of the sheet on the button.

Also, be sure to protect the VBA project with a password as well, else someone can view the code to read the passwords.