Hidden sheet tabs (to store data)???

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

Robert Crandal

I am thinking about using a separate sheet in my workbook
to act as kind of a database of information which I want to
keep separate from my other sheets.

However, I do not want my users to be able to see this
data sheet. Is there a way to make a sheet hidden?? Can
the tab for the data sheet also be hidden??

Thank you!

Robert
 
Hiding the sheet will also hide the tab.
In version 2003, select your sheet that you want to hide and then on the
menu select Format -> Sheet -> Hide

In version 2007, right click on your sheet tab and select hide.
 
You can also make the sheet "VeryHidden", but you have to do that from within
the VBE. A very hidden sheet can't be seen by someone who tries to unhide
it using "normal" methods.

Alt F11
F4 to see the properties window if it's not there.
Select the worksheet to hide and under VISIBLE change it to XLSheetVeryHidden
 
Back
Top