Password Macro to view/hide specific tabs and rows

Here is a macro the should work for you.
I also attached a workbook you can use to copy your own sheets to.
The macro being already working inthis workbook, you should have no problem.

If you want to see the VBA code, the project is protected by a password being: Password
You can get to the Visual Basic Editor by clicking on ALT+F11.
You should see the project named MKLESS.xlsm
If you double clink on it, it will ask you your password. Enter: Password

In the code, all you sheets password have been set to Password.
You can change this for your own password.

The macro looks for a sheet with the word "Summary" in its name.
Any sheet with the word Summary in its name will be hidden when asked to.
All other sheet name will see their rows 1 to 4 hidden

You can run this macro by clicking on the VIEW menu and then on the Macro one.
A window should open and show you all the macros available.
If there is too many of those, you can select to show only those of This Workbook.
Double click on the macro name or click on it once an then on RUN. Then follow the instructions.

Here is the code:

Please Login or Register  to view this content.

You can change the wording to suit your need.
I hope this will help you.
Regards