Completely hide a sheet

L

Lynxbci3

Hi,

I know you can hide a sheet using the menu. But, is there any way yo
can completely hide a sheet from view and not let other users ever ge
into it? Not just password protecting it, that is easily overcome.

Thanks

Lynxbc
 
D

Don Guillett

You can hide with a macro using
sheets("sheet4").visible=xlveryhidden

which can ONLY be unhidden by using code.
Then password protect your code which is more difficult to break
 
E

Earl Kiosterud

Lyn,

In the VBE, you can manually set its Visible property to "xlVeryHidden".
Now the sheet can't be unhidden with the ordinary means -- Format - Sheet -
Unhide. To do this, go to the VBE (Alt-Fll), select the sheet in the
Project Explorer, and open the Properties Window (View - Properties Window).
Keep an eye on which sheet is selected when you make a change in the
properties window, as it may move the selection down to the next sheet.
You'll need to lock the project (Tools - VBA Project Properties - Protection
tab) if you think anyone might know how to reset this.
 
Top