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

Hi Alex,

A hidden sheet cannot be selected, so try re-writing your code to remove
selections.

If this does nor resolve your problem, post your code.


---
Regards,
Norman


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