Code to automatically save workbook automatically???

[siasarma]

I am wondering if anybody has a code that I can paste into my worksheet that will automatically save the workbook every once in awhile??? Or maybe every time there is a change to it or something??? Any ideas??? Thanks!!!

 

[venkat1926]

use event code. rightclick excel icon on the left of "file" in menubar and click view code.
on the left side arrow choose workbook on the risht side arrow choose sheetchange.
write your code.something like this
workbooks(...).save
the first you save manually.
note that the file will be saved everytime you change any cell in any sheet. you can restrict his to change in cells in a range in particulr sheet.

 

[xenou]

You can also just just get in the habit of hitting {Control + S} frequently and making backups at every important step in your work or development.

 

[Smitty]

You can goto Tools-->Options-->Save-->Set the AutoRecover time.