Reduce Flashing
Thank you, Trevor, but application.screenupdating=False prevents the
display of the various sheets. Evidently, if I put this instruction in
before the next sheet is activated, the screen fails to show the next
sheet. If I put it after the next sheet is activated, it's too late to
prevent the sheet from updating itself. James
Trevor Shuttleworth wrote:
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
|