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?

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?
.