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