How can this code be modified in order to stop a macro from running every 5 minutes?
Public dTime As Date
Sub StopTimer()
On Error Resume Next
dTime = Now + TimeValue("00:05:00")
Application.OnTime dTime, "Macro2", False
End Sub
Any help is greatly appreciated.