hiding worksheets

F

frendabrenda1

I am trying to a hide a worksheet that is referenced in one of my macros. Is
there a way to hide the worksheet without removing its availability to the
macro?

I am using Excel 2003.
 
J

JMB

It also depends on how your code references the worksheet. If you try to
select or activate a hidden sheet you'll get an error.

If you are referencing the sheet w/o selecting or activating it, you should
be okay.

If you hide the sheet and have problems, you can have the macro unhide the
sheet, then rehide it.
 
Top