Thread: Macro's Flicker
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_7_] Gary Brown[_7_] is offline
external usenet poster
 
Posts: 14
Default 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?
.