How to stop Macro from looping

Hello all,

I have a macro code that automatically saves after every 15 minutes. however, after closing the sheet (not excel) and opening a new program. It opens the program with the macro that saves every 15 minutes without me trying to open it.

Here's the code in ThisWorkbook

Please Login or Register  to view this content.

Code in Modules

Module 1

Please Login or Register  to view this content.

Module 2

Please Login or Register  to view this content.

Thanks for your help.

Does appear you have an infinite loop.

Sub saveIT calls Sub UpdateTime. Sub UpdateTime calls sub saveIT. There is no stopping mechanism. Both are in modules of this workbook.

To clarify, you have closed the Excel workbook containing these modules, but not Excel (correct?). The some other program you launched is saving every 15 minutes? Can you tell us what that other program might be? Maybe we could try to recreate the situation with more details.

Cam

Originally Posted by ctmurray

Does appear you have an infinite loop.

Sub saveIT calls Sub UpdateTime. Sub UpdateTime calls sub saveIT. There is no stopping mechanism. Both are in modules of this workbook.

To clarify, you have closed the Excel workbook containing these modules, but not Excel (correct?). The some other program you launched is saving every 15 minutes? Can you tell us what that other program might be? Maybe we could try to recreate the situation with more details.

Cam

To clarify, let's say I close the workbook (but not excel) and I open a another spreadsheet or a new sheet. For some reason, a window that ask to enable macro opens and if I click enable or disable, the spreadsheet that contains the macro to autosave every 15 minutes pops-up, and if i close it, it will re-open after 15 minutes. It seems like the code resides in the memory and it doesn't clear until I close the excel program.

Is there another way to autosave the sheet ever 15 minutes (specified time) besides using the code i'm using?

Thanks in advance.

Originally Posted by davesexcel

Please elaborate between closing a sheet, and closing a workbook...

Dave, sorry for the confusion.
I meant closing the workbook, not excel.

thanks.

Originally Posted by mikerickson

Putting this in the ThisWorkbook code module should disable the OnTime.

Please Login or Register  to view this content.

For some reason this is not working. Is it because of Workbook_BeforeClose?

thank you.