don't forget to reset to true at the end

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Jerry Park" wrote in message
. ..
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?

Application.ScreenUpdating = False

Calculations can also slow down your macros. You might want to add
Application.Calculation = xlCalculationManual to the start of your macro
and Application.Calculation = xlCalculationAutomatic to the end.