Timer Macro Causes WB To Save While Closed

I have a macro that starts a timer when the workbook is first opened. When the timer hits "0", the workbook saves and closes. Works fine. I also have it where when the workbook is "Read-Only", the timer does not trigger the "save and close" of the macro. If I have another instance of excel open, and close the macro enabled WB, the macro still runs, even though the WB I have open now has no macros in it.

It will still run the "save and close" function of the original WB macro.

Is there anything I can add to it to make it specific to that WB with the timer macro? Even when it's closed without saving, it still runs the save if there is another excel sheet open.

Any help would be greatly appreciated!

Thank you in advance!

Please Login or Register  to view this content.

Please Login or Register  to view this content.