stop calculating and "ding"

[Guest]

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?

 

[Pete_UK]

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

 

[Gord Dibben]

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