Thread: Heartbeat code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ajtb Ajtb is offline
external usenet poster
 
Posts: 41
Default Heartbeat code


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