Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro cannot access hidden sheet
My macro works fine until I hide a sheet that it needs to use. The code stops
at the last line below: Dim r As Range Sheets("Main Page").Select If IsError(Range("B3").Value) = False Then GoTo DoubleClick Set r = Range("D5:M5") Sheets("Part Numbers").Select < Unhiding the sheet (Part Numbers) clears up the problem, but I would prefer to have it hidden. What's the trick? Thanks. Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to run on hidden sheet | Excel Discussion (Misc queries) | |||
Refer to a hidden sheet using a macro. | Excel Programming | |||
Using a Macro to look at Hidden Sheet | Excel Discussion (Misc queries) | |||
Macro for hidden sheet access | Excel Programming | |||
Macro dependent on hidden sheet? | Excel Programming |