View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Martins[_2_] Alex Martins[_2_] is offline
external usenet poster
 
Posts: 29
Default CHOOSE TO STOP A MACRO OR NOT

Hi. Is there a way to have a macro constantly running and to stop it by
clocking on a msg box?

For example. I have a macro that performs a repetitive operation over and
over. And that's what I want it to do! But at the end of the day, I wan to be
able to stop the macro. I tould be great to have a button in a msg box that
went:

"CLICK "OK" TO STOP RUNNING", and if I did, it would stop the code from
executing.

Any ideas?

Many thanks in advance. You've all been very helpful more than once!
Alex