Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden sheets and macros
I have a macro that references some data on a sheet I wish to have hidden in my workbook. The macro abends because the sheet is hidden. Is there some way to reference the hidden sheet in the macro so it will execute? -- mwc0914 ------------------------------------------------------------------------ mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130 View this thread: http://www.excelforum.com/showthread...hreadid=558479 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden sheets and macros
A simple solution would be to make the sheet visible during execution of the macro then hide it again at the end. Put this at the start of your code: application.screenupdating = false sheets("TheHiddenSheet").visible = true and this at the end: sheets("TheHiddenSheet").visible = false application.screenupdating = true That way the sheet will be available to the rest of your macro, but the user won't see it appear and disappear. Col -- colofnature ------------------------------------------------------------------------ colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356 View this thread: http://www.excelforum.com/showthread...hreadid=558479 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets | Excel Programming | |||
Where are the hidden macros? | Excel Programming | |||
Macros with hidden sheets! | Excel Programming | |||
running macros on hidden sheets? | Excel Programming | |||
Hidden? macros | Excel Programming |