run macros in background

[Papa Jonah]

My macros involve a lot of copying pages, reformatting, adding formulas,
plotting, etc.
When a macro runs, it can take several seconds. Meanwhile you are watching
Excel go through all sorts of contortions as things are happening.

Is there anyway to cause either:
1) the screen to effectively "freeze" until the macro is complete,
or
2) go blank or some other less stressful appearance until the macros are
done running?

TIA

[JulieD]

Hi

use
Application.ScreenUpdating = False
at the top of your code and
Application.ScreenUpdating = True
at the bottom

Cheers
JulieD

"Papa Jonah" <[email protected]> wrote in message
news:[email protected]...
> My macros involve a lot of copying pages, reformatting, adding formulas,
> plotting, etc.
> When a macro runs, it can take several seconds. Meanwhile you are
> watching
> Excel go through all sorts of contortions as things are happening.
>
> Is there anyway to cause either:
> 1) the screen to effectively "freeze" until the macro is complete,
> or
> 2) go blank or some other less stressful appearance until the macros are
> done running?
>
> TIA