OnTime problem

[JackDanIce]

Hi,

I've just started using Application.OnTime and find that it works 99% of the time to trigger an event at a pre-defined time. However, the few times it doesn't work does cause issues.

Can anyone explain why this is or any suggestions/comments on work arounds?

Thanks,
Jack

 

[RoryA]

OnTime will run at the scheduled time if it can but only within the same session of Excel. If you close and restart Excel, the schedule is gone. If there is another reason why a macro can't run (dialog on screen, in edit mode) it also won't run at the exact time specified.

 

[JackDanIce]

Thanks Rory

 

[RoryA]

No worries.

PS Shouldn't it be Alan Partridge?

 

[JackDanIce]

Don't correct my signatures! Grrr now I have to find a new one, THANKS rory and I really liked that one too!