View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron[_32_] Ron[_32_] is offline
external usenet poster
 
Posts: 36
Default Simple on/off swith to turn macro on/off?

Hi Bob,

I agree, I could do that. I'm not overly sure of the syntax (if any) to
kill any remaining 'ontime' requests. I don't want the application
resurrecting the previous 'ontime' requests.

If I had OnTime requests set to (say) every 2 minutes through the day,
could I cancel the remaing requests with code if the scenario Im looking
for flagged up?

Thanks for your help anyway Bob.

Ron



"Bob Phillips" wrote in
:

I think you could do all of that with the technique that I described
Ron. The button could issue the first OnTime macro, loading the cell
could stop it, and the button could restart (and clear the cell)