turning off ON_TIME

I have an ON_Time routine running. My book is in another county. How do I stop this thing from opening itself up and running. How do I stop a sub that has been set to run On_Time?

Later edit:
Cool down. I figured I could kill the reset start time part of the routine. The weirdness of a closed file opening itself threw me for a bit.

To generalize

if I have a sub

Please Login or Register  to view this content.

What code, in a different sub will tell excel to stop running mySub every 10 seconds.

I also posted this on the other website.

This example cancels the OnTime setting. Looks like you need to know the next schedule run time.

Please Login or Register  to view this content.

Another option is to use a variable that is available to both macros (Boolean type)

have your cancel macro set it to true and the ontime macro test its true or false setting

Please Login or Register  to view this content.