save workbook on time

[Kash]

ThisWorkbook.save

I have above code to save workbook every half an hour, which works fine..
But even when I open this file and close it, still every half an hour it
opens on its own and saves.

How to overcome this?

 

[Dave Peterson]

Tell excel to stop the timed macro when the workbook closes.

Take a look at Chip Pearson's notes:
http://www.cpearson.com/excel/OnTime.aspx

You'll see how he uses a variable to hold the next start time and how he uses
that to stop the timer.