Completely hide a sheet

  • Thread starter Thread starter Lynxbci3
  • Start date Start date
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
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding VB Code 5
hiding formulas 2
hide columns on a protected sheet??? 1
hide, unhide column or row after protect worksheet 4
Toolbar buttons to hide/unhide sheets 8
password protect a sheet 5
Unhide Multiple Sheets 2
customize what work sheet to hide. 1

Back
Top