Stop application.ontime

[voltrader]

Below is a script I'm trying to use to stop the Application.ontime "nextTick" macro I have running.

Public Sub StopClock()
'Cancels the ontime event StopclockEG
On Error Resume Next
Application.OnTime NextTick, "stopclockEG", , False
End Sub
------
The script is not stopping the timer(macro StopClockEG) though, any suggestions thoughts?

Thanks!

 

[Andrew Poulsom]

Where have you declared NextTick? And where have you assigned a value to it? Here is an excellent write-up on the OnTime method:

Pearson Software Consulting

 

[voltrader]

NextTick is declared & assigned a value in the sub "StopclockEG".

Thanks ill read through Pearson.