View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David
 
Posts: n/a
Default Screen redrawing

Hi,
I've seen and religiously use the oft suggested technique to stop screen
flicker/refresh with running macros:
application.screenupdating=false
your code
application.screenupdating=true

I have one workbook, however, that merely switching between workbooks will
cause this workbook to redraw its selected sheet 3 times! Very annoying.

Could it be that its Workbook_Activate routine adds custom menus? Other
workbooks don't act that way even when menus are added. I've even gone so
far as to include all three:
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual

No change.
Can anyone shed light on this phenomenon, or offer a solution?

--
David