G
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?
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?