I have a workbook that runs a timed macro.

However whilst I have other Workbooks open this Macro continues to run.

How to you stop any macros on Workbook?

I have tried this but cant get it to work :-





 Private Sub Workbook_BeforeClose(Cancel As Boolean)
 Application.OnTime Now + TimeValue("00:50:00"), Procedure:="SaveThis", schedule:=False
 End Sub


 Private Sub Workbook_Open()
 Application.OnTime Now + TimeValue("00:50:00"), Procedure:="SaveThis", schedule:=True
 End Sub