save workbook on time
 

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?

save workbook on time
 

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.

Kash wrote:

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