PW Protected Macros Needed to 1) Hide Certain Worksheets & 2) Unhide Worksheets & Columns

[Aimee S.]

Greetings, Excel Friends

I could use some expertise/guidance on this request. I require two macros that are password protected to hide or unhide vital imformation that only persons who maintain the workbook should be able to view. Here are descriptions of each:

Macro/VBA #1: Entitled 'Unlock_Hidden_Material'
What it needs to do:

1) Prompt user for a password (password entry box with OK and Cancel). If user enters correct password into prompt box (password is 'NIOSHSD') then the rest of this macro would proceed. If nothing or the incorrect password is entered into the password prompt box, nothing happens and the macro does not run.
2) If password is correctly entered the VBA: Unhides HIDDEN worksheets 'Paste BI Report Here' and 'Macros'.
3) Lastly, I need this to unhide columns A, B, C, and H in worksheet that is never hidden and always present called 'WI SHSD'.

Macro/VBA #2: Entitled 'Lock_Hidden_Material'
What it needs to do:

1) Prompt user for a password (password entry box with OK and Cancel). If user enters correct password into prompt box (password is 'NIOSHSD') then the rest of this macro would proceed. If nothing or the incorrect password is entered into the password prompt box, nothing happens and the macro does not run.
2) If password is correctly entered the VBA: (re)-HIDES worksheets named 'Paste BI Report Here' and 'Macros'.
3) Lastly, I need this to (re)-HIDE columns A, B, C, and H in worksheet that is never hidden and always present called 'WI SHSD'.

I am deferring to your excel wisdom for guidance with this last piece of the puzzle for a massive project I have been working on for many months now! :D

[D0se]

Please Login or Register  to view this content.

[Aimee S.]

This worked great! Thanks very much :D

[Aimee S.]

Hi. So, as for my thread title, I have a specific solution that must be in place but I did not know how to do it. In other words, I am not so lost as to say: How Do I Hide or Unhide Worksheets, but rather know for a fact that I required a password protect prompt proceeded by a hide worksheets/columns or unhide them etc.

May I ask how I would otherwise word this specifically? I read the rules and am at a loss. Not trying to troll - just the first time I have ever been flagged for this. Thanks!
Aimee

[JBeaucaire]

After additional review, your thread title is fine. We appreciate the thought put into accurate titles and yours suffices.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Aimee S.]

Thanks. I've marked the thread as SOLVED.