Hide Sheet

[dipsy]

I want to hide a sheet in a workbook. The sheet should be
visible only when I type a password. Is there a way to do
this. Does this need to be done through VBA.

Thanks in advance.

 

[Earl Kiosterud]

Dipsy,

You can protect the workbook. Tools - Protection - Protect Workbook. This
will disallow adding, moving, deleting sheets also though.

Or use this code:
Sheets("Sheet2").Visible = xlVeryHidden

A user won't be able to use Format - Sheets - Unhide. Only code can unhide
it. This doesn't require that the workbook be protected.

 

[John Wilson]

dipsy,

Open the VBA Editor. (Alt + F11)
Open the "Properties" window (F4)
Select the sheet you want hidden in the "Projects" Window (upper left)
Change the "Visible" property of the sheet to "VeryHidden" (lower left)
Then select
Tools/VBA ProjectProperties
Protection tab
Check "Lock Project for viewing"
Enter passwords
Save the file.

John