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.
"frendabrenda1" wrote:
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.
|