View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Simple on/off swith to turn macro on/off?

You could use OntIme to schedule it to run at a given time, and then each
time fire it off 2 minutes later. Within that routine, you could test a
worksheet cell, and if a certain value, then just abort. You just set that
cell when you want to abort.

Chip has a good page about OnTime at
http://www.cpearson.com/excel/ontime.htm

--

HTH

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


"Ron" wrote in message
...
Hi Guys,

I am creating a macro that will web query every two minutes or so
throughout the business day. What's the simplest way to be able to 'turn
it off' without hitting Esc to break the code?

Any suggestions welcome.

Ron