View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jerry Park Jerry Park is offline
external usenet poster
 
Posts: 23
Default macros and screen updates

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.