Once you quit Excel, all OnTime events are cleared. Therefore,
you would need to schedule an OnTime event in the workbook's open
code. This assumes that Excel will be open. You can use
Window's Scheduled Tasks tool to automatically open Excel at a
given time, and then in that workbook's Open code, run the code
or schedule an OnTime event.

I wouldn't recommend using Windows API timers (even though I
describe them on my web site) because they will cause Excel to
close immediately if Excel is in Edit mode (e.g., you are editing
the contents of a cell).


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


"R Avery" wrote in message
...
Chip Pearson wrote:

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.


Oh - If quitting Excel clears all scheduled procedures, is
there anyway
to ensure that a procedure executes at a particular time,
regardless of
how many times i have quit Excel?

Perhaps in my Personal.xls OnOpen Workbook event I could
schedule the
event? Or would the API Timer function work regardless of
whether or
not Excel was closed?