Do already running macros terminate if the excel workbook is closed?

[Visceral]

Hi All,

Consider the below macro -

Please Login or Register  to view this content.

So the above macro basically runs every 1 minute (the execution time is well less than 1 minute). But the trouble is that if I close the excel workbook to which this macro is associated but keep other excel sheets open, the macro still runs when it's 1 minute is over.

How can this problem be overcome. I was under the assumption that closing an excel sheet will automatically terminate all the macros associated with it.

[jrdnoland]

You have to "Turn it Off"

Please Login or Register  to view this content.

[Visceral]

You have to "Turn it Off"

Please Login or Register  to view this content.

Can you throw some more light..

[Visceral]

Ok JRDNO, that helped. Thanks.

I had to put it this way. Time2 had to be defined as a global variable and WORKBOOK_NAME is a global constant with the workbook name.

Please Login or Register  to view this content.

Every single line was important. Wish there is an easier way.