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