Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro's Flicker
I have a long macro that references macros in another
workbook. It unlocks and makes visible hiden pages, does several cuts and pastes, triggers other macros etc. I have the Application Screen Updateing set to false in every sub macro and on the main macro. Why does it still flicker as if I don't? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro's Flicker
If, at the end of each sub macro, you are setting the
Screen Updating to True, for that brief moment before the main macro hits another sub macro with another updating = false line, the screen will update, causing flicker. HTH, Gary Brown -----Original Message----- I have a long macro that references macros in another workbook. It unlocks and makes visible hiden pages, does several cuts and pastes, triggers other macros etc. I have the Application Screen Updateing set to false in every sub macro and on the main macro. Why does it still flicker as if I don't? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen Flicker | Excel Discussion (Misc queries) | |||
List box screen flicker | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
Preventing screen flicker | Excel Discussion (Misc queries) | |||
Screen Flicker | Excel Programming |