MrExcel.com - Your One Stop for Excel Tips & Solutions

Hide a Worksheet

Posted by Steve on October 01, 2001 7:12 AM

I have one workbook with three sheets and I would like to hide one sheet so that no one but me is able to view that sheet, is this possible.

Posted by Juan Pablo on October 01, 2001 7:19 AM

You can hide the sheet (Using Format - Sheets - Hide) and the protect the book (Using Tools - Protect - Protect book) and assign a password, that way no one can unhide your sheet.

If you don't want to protect the book you can use VBA.

Juan Pablo

Posted by Steve on October 01, 2001 8:14 AM

Juan, It worked. Thanks for the help.