Just to add, never schedule more than one event and save the time you used
for it in a global variable. Have the scheduled event schedule the next
event.

See Chip's page for a workable approach

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

"Chip Pearson" wrote in message
...
There is no way to determine what has been scheduled with OnTime.
The only way unschedule an event is to use the *exact* scheduled
time in a call to OnTime with the Schedule argument set to false.
There is no way to clear all scheduled events short of closing
Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"R Avery" wrote in message
...
Is there any way to determine what procedures are scheduled
(with
Application.OnTime) to run and when? Or, supposing I already
know the
procedure name, is there anyway to determine when it has been
scheduled
for? Also, is there any way to completely erase all scheduled
events?
Any help would be most appreciated.