Maybe add a line at beginning of macro to prevent calculation.

Application.Calculation = xlCalculationManual

You will have to reset at some point back to

Application.Calculation = xlCalculationAutomatic


Gord Dibben MS Excel MVP

On Thu, 25 Jan 2007 11:45:01 -0800, GoBobbyGo
wrote:

I'm running Excel 2003.

I work with a lot of spreadsheets that take minutes, as opposed to seconds,
to calculate. I often realize just a little bit too late that calculation is
set to automatic just after I start a macro that will now take a ridiculously
long time to run. And ctrl-break seems to not work to stop the macro if it's
calculating.

Is there a way to stop Excel from calculating, once it starts, short of
ctrl-alt-del?

Also, I often do run macros that will take a long time, and I'd like to do
something else while it's running. Is there a way to play a sound in a
macro, so that I'll know when it's done?