Tim

Early on in code use these lines

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual


At end of code these

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True


Gord Dibben Excel MVP - XL97 SR2 & XL2002


On Fri, 1 Aug 2003 08:42:12 -0700, "Tim Laud" wrote:

I've written a macro that updates several sheets and
graphs. Execution is very slow because of the constant
refreshing of the display.

Is there a way to turn off the screen updates until the
macros have finished?