Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |