Protecting Tabs

C

Chip Pearson

In VBA you can set the Visible property of the sheet to
xlVeryHidden. The only way that the sheet can be made visible is
with VBA code.

Worksheets("Sheet1").Visible=xlVeryHidden


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
A

Andy B

Hi

You could use the VBA window to make the tab (sheet) hidden. It is still
possible to unhide it but your average user wouldn't even know it exists.

Right click on the icon to the right of File.
Left click on View Code
If you cannot see the window marked Project, hit Ctrl R. Select the sheet
you want to hide in this window
If you cannot see the window marked Porperties, hit F4. With the correct
sheet selected above, change the Visible attribute to Hidden or Very Hidden.
Then you can close the VBA window.
 
Top