Reduce Flashing

[Zone]

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

 

[Trevor Shuttleworth]

Try:

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

Regards

Trevor

 

[Zone]

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

 

[NickHK]

As your need to show each step of the "animation", that is what you are
seeing. If there are blocks of code that you do not need the user see, then
sandwich them in .DisplayAlerts=false/True statements.
Not sure, but playing with Application.Calculation and possibly
Worksheet.DisplayPageBreaks, may help.

NickHK

 

[Greg Glynn]

Another thing to try is putting

Application.Screenupdating = True
Application.Screenupdating = False

.... pairs of code-lines at the places in your process that you want to
see what has been updated. It has the effect of redrawing the screen
and then freezing it again.

 

[NickHK]

Yes, that I meant, not .DisplayAlerts.
Don't know where taht came from.

NickHK