stop calculating and "ding"
 

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?

stop calculating and "ding"
 

You could put a Beep (or several) at the end of the macro, or if you
would like something like a short fanfare from a small .wav file, then
this link shows how to do this:

http://www.cpearson.com/excel/excelM.htm#PlayWAV

Hope this helps.

Pete

On Jan 25, 7:45 pm, 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?

stop calculating and "ding"
 

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?