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.

Yes, go to Format, Sheet, Hide

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

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.