Bdcrisp wrote:
No matter how hard i try .. when the user closes the file it
always asks to reopen the file.. the ontime command has something to do
with that.. ive tried to shutdown the timer but it doesnt seem to work.


If you use my code (earlier in the thread) as a model you should avoid
this - as long as you only start one sequence of events. While debugging
this can be difficult to achieve (if you reset the project you lose the
value of dNextTime and so can't use it to cancel the next event).
You could overcome this by using a worksheet cell instead of a VBA
variable to hold the next scheduled time. Or just make sure to exit from
Excel when closing the file.




Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup