Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a simple macro | Excel Worksheet Functions | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
excel 4.0 macro remover tool | Excel Discussion (Misc queries) | |||
hide a worksheet so that a macro can still find it | Excel Worksheet Functions | |||
Can a macro format a hidden sheet? | Excel Discussion (Misc queries) |