View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Metallo
 
Posts: n/a
Default Macro and hidden sheets

Hi,

I have a WB with 10 worksheets.
At the time I did this WB, I also created a Macro that had the task to
change the format of all the sheets.
Today, I have decided to hide some of the sheets and the macro does no
longer work.
I guess this is because it cannot find the sheets which are hidden.

My question is: Is there a way to allow the Macro to work as before, meaning
to continue changing the format of the hidden sheets as well?
Something like a condition that says, if Sheet XY is hidden then look for it
into etc.

Thank you
Alex