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
|