View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_20_] Peter[_20_] is offline
external usenet poster
 
Posts: 20
Default Suspend/resume running of a macro

Hi all
Any help would be greatly appreciated.

Is there a simple way of allowing the user to pause (suspend) a macro and
then allow it to resume, say, on <Enter key?

Platform: Excel 2000

Background: I have written an event timer (countdown in minutes) for each
round in a bridge competition and occasionally need to manually pause it for
a minute or so if there is a hold up in play. (The timer is a guide only -
does not need to be 100% accurate).
I can use Ctrl-Break and then resume, but this is rather clumsy and
unprofessional.

I did a Google search and it seems that this simple request is NOT possible!
However maybe the experts have now found a way!

If not possible please just say so and I will continue using Ctrl-Break.
Yuk!

Thanks,
Peter Bircher