I have a macro that runs another macro every 5 minutes and loops, using the Application.OnTime Now + TImeValue("00:05:00"), "AnotherMacro"
But my problem is if you just close the workbook, but not the Excel application this macro continues to run re-opening the spreadsheet. Does any one have any suggestions as to how to stop the macro when I close th workbook?
Thanks
Liz
Bookmarks