Thread: Reduce Flashing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Reduce Flashing

Try:

Application.ScreenUpdating = False
' your code
Application.ScreenUpdating = True

Regards

Trevor


"Zone" wrote in message
oups.com...
Excel 2002. My workbook has about 30 worksheets which I activate
sequentially to simulate animation. Problem is, Excel seems to want to
clear each worksheet in turn as it is activated and then re-display all
the drawing objects on it. This causes a distracting flashing as the
worksheets are activated. Is there a workaround for this? TIA, James