Does anyone have any code that will indicate if a macro is
running? I have a continuous running macro that updates
every 2 secs. Sometimes several updates occur without
changing any data on the screen. Sometimes the macro hangs
up. I would like a "heartbeat" to indicate if it was
really running or not. Maybe like cells alternating
colors, or cycling through Clip Art objects?

Thanks,
Mike

Hi
Have the running macro print something in the status bar.

Regards
Andrew Bourke


Mike K wrote:
Does anyone have any code that will indicate if a macro is
running? I have a continuous running macro that updates
every 2 secs. Sometimes several updates occur without
changing any data on the screen. Sometimes the macro hangs
up. I would like a "heartbeat" to indicate if it was
really running or not. Maybe like cells alternating
colors, or cycling through Clip Art objects?

Thanks,
Mike

Mike,

Use some sort of progress indicator, either a progress bar form writing to
the status bar, or just displaying a message box for a determined period.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike K" wrote in message
...
Does anyone have any code that will indicate if a macro is
running? I have a continuous running macro that updates
every 2 secs. Sometimes several updates occur without
changing any data on the screen. Sometimes the macro hangs
up. I would like a "heartbeat" to indicate if it was
really running or not. Maybe like cells alternating
colors, or cycling through Clip Art objects?

Thanks,
Mike

Bob,
Just got back to work today. This macro may run for 8-
12 hours, or theoretically days or weeks. Doesn't a
progress indicator need a definite start and a stop? And
if the macro were to hang, wouldn't the display still
remain? I have a status cell(A1) turn green when I click
the start button and red when I click the stop button.
Sometimes the macro hangs on its own, doesn't update, and
the status cell stays green. If I had another cell
alternate colors continuously, or an animated dohicky,
then I could tell if it were truly running.

Mike


-----Original Message-----
Mike,

Use some sort of progress indicator, either a progress
bar form writing to
the status bar, or just displaying a message box for a
determined period.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike K" wrote in
message
...
Does anyone have any code that will indicate if a macro
is
running? I have a continuous running macro that updates
every 2 secs. Sometimes several updates occur without
changing any data on the screen. Sometimes the macro
hangs
up. I would like a "heartbeat" to indicate if it was
really running or not. Maybe like cells alternating
colors, or cycling through Clip Art objects?

Thanks,
Mike


.