Application.Ontime vba

[p4nny]

hi

I would like to cancel / kill the "application.ontime" on exit of the workbook

Application.OnTime Now + TimeValue("00:10:00"), "savethis"

the workbook keeps reopening once I close it

Appreciate the guidance

cheers

 

[RoryA]

You need to store the scheduled time in a variable to cancel it. Have a read of this: Pearson Software Consulting