MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to Protect hidden sheets i.e., need password to unhide


Posted by Irene on March 09, 2001 3:25 AM

I have a large workbook. I need to hide several sheets and be able to protect them so no-one else can unhide them without a password. Is this possible? My version is Excel 2000.

Waiting in hop of an answer...........


Posted by Dominic on March 09, 2001 6:26 AM

Hi

One answer is to go to your Macro Editor,
┬┤Do the following on your toolbar
Extras
Macro
Visual Basic Editor
Double Click on the correct Project in the Explorer window
Click on the required Sheet name
Then look at the Window called Properties and you will see a property called visible
Change the value to Very Hidden
Then Right Click on the Main Project again
go to Project Properties and password protect the project.

this is a way of hiding and therefore password protecting individual sheets

Posted by Irene on March 14, 2001 5:16 AM

Knowledge is a wonderful thing. Thanks a million it work a treat.