Protecting Tabs

  • Thread starter Thread starter eroszzz
  • Start date Start date
E

eroszzz

Is there a way to hid a tab and make it so no one else can unhide it
 
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
 
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.
 
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

how do i unhide a worksheet in excel 2003? unhide tab don't work 2
subs and hidden tabs 4
How do I unhide Column A of an Excel spreadsheet? 12
hidden columns disappear after I unprotect worksheet 2
Macro Help 9
unhide rows 12
Don't want to hide anymore 1
columns won't unhide 2

Back
Top