Stopping a Macro, Temporaily

[krn6264]

I have a macro running automatically with the following code

Application.OnTime Now + TimeValue("00:05:00"), "Report"

How do I pause this so I can make updates on other areas of the spreadsheet without it running.

 

[Todd Bardoni]

You could open the VBE and add a breakpoint right in the beginning of the macro and then delete the breakpoint after you make your changes.

 

[krn6264]

Thanks for the info, but could I create a macro to halt the ontime event and assign to a button on the spreadsheet???

 

[krn6264]

Thanks for the info, but could I create a macro to halt the ontime event and assign to a button on the spreadsheet???

 

[Jengor]

A button is assigned the macro StartTimer

Public Timestart As Boolean

Sub Doit()
    If Timestart Then
        Application.OnTime Now + TimeValue("00:00:05"), "Report"
    End If
End Sub

Sub Report()
    MsgBox ("Here is the report")
    Doit
End Sub

Sub StartTimer()
    Timestart = Not Timestart
End Sub

HTH you to develop your solution.