Hiding specific tabs with Password protection

I am trying to figure out a macro that will hide specific tabs and that hidden tabs are password protected. But mainly hide specific tabs. I found macros that will hide and restore all tabs but not certain tabs.

I have attached the sample file. (I already have the "Hide all and Restore All" macros.) I am still learning and a complete newbie when it comes to VBA.

Tabs labeled "Instructions", "Cover sheet", 'Monitoring Units Worksheet" are to remain visible while
"Monitoring Values Worksheet", "Medical Monitoring", and "Monitoring Calculator" are hidden and if possible requires a password to open

Please be sure to include specific instructions on how to accomplish this as I am like a nervous nellie behing the steering wheel for the first time when it comes to implementing macros!

Hope this is relatively easy

Hello dawnmau,

I have added 2 macros and a user form to your workbook. The user form asks for a password to unhide the restricted sheets. The 2 macros hide the sheets and call the user form to show them. In VBA worksheets can be either hidden or very hidden. The difference is a worksheet that is very hidden can only be made visible again through macro code. When worksheets are very hidden, the user doesn't even know they exist, unless they open the VB editor. If you want to add another level of anti-tampering, you can password protect your VBA project. This will keep more experienced users form being able to see your VBA code. Here are the macros and the UserForm code.

Module1 Macros

Please Login or Register  to view this content.

UserForm1 Code
Change the password in bold to what you want.

Please Login or Register  to view this content.

Ok I like the solution, however I have been informed that they do not need a password to "unhide". I tried to write a couple of version of an "unhide" macro and have been unsucessful. Help!

Hello dawnmau,

Here is the code to show the worksheets.

Please Login or Register  to view this content.

Aha!! I now see my mistake!! Thank you so much for your help! PS I changed the 2nd "End With" to "End Sub" and it workds perfect. I also associated a Ctrl Shift hot key with both macros. This lesson will go a long way with understanding some of the coding.

*********** 10 stars for you!