Stopping Application.ontime when the workbook is closed

636 Views Asked by At

I have a very simple code below that works to run a macro at a set time. The issue I'm having is that if the workbook is closed, it will reopen itself to run the macro at the correct time. The only way to stop it is if the computer had been turned off/restarted. I have seen some answers to similar issues but I haven't fully understood the answers as my experience with VBA is very limited. They also had more code in their ontime request so I'm hoping that my issue might be a more simple fix. Any advice would be greatly appreciated.

Private Sub Workbook_Open()



    Application.OnTime TimeValue("08:10:00"), "ButtonRefreshDays"



 End Sub
0

There are 0 best solutions below