SHEETS

  • Thread starter Thread starter Jonny
  • Start date Start date
J

Jonny

This may be really simple, but is there a way to hide a
sheet in a workbook that is used for bits of information
the user isn't concerned with but the VBA code is.
 
Jonny,

I assume that Format/Sheet/Hide isn't secure enough for what you want to
do??

Manually, you can select the sheet from the VBA editor and change it's
Visible
property to VeryHidden.

Via code:
worksheets("yoursheetname").visible = xlveryhidden

To make it visible again, change the Visible property manuall as above or
worksheets("yoursheetname").visible = True

The VeryHidden property insures that the sheet won't show up on the
Format/Sheet/UnHide menu.

John
 
Jonny said:
This may be really simple, but is there a way to hide a
sheet in a workbook that is used for bits of information
the user isn't concerned with but the VBA code is.
Click to expand...

You can hide a sheet using Format/Sheet/Hide (I guess, I use Spanish
Excel). At least this is in Excel 2002.
To find out the VBA code to do this, just record your steps while doing it.

Regards,
 
Back
Top