Hi,
I have the following code:
Sub UpdateTime()
Call Macro2
RunWhen = Now + TimeSerial(0, 0, 60)
Application.OnTime RunWhen, "'" & ThisWorkbook.Name & "'!UpdateTime", , True
End Sub
Unfortunately I cannot get this macro to end. I have tried inserting an end if macro attached to a button on my sheet but the ontime seems to override it and still won't stop. Any help in ending this macro (ideally using a button on my sheet) without having to exit the whole workbook would be most appreciated!
Thanks very much in advance,
Phil
Bookmarks