auto save

[carrie3119]

can an excel sheet have an auto save

[Don]

Hi and welcome to the forum!

Do you mean a way to have it automatically do the same thing as it does when you click the save button? If so, follow these steps:

Insert a macro into your workbook:

Code: Select all

Sub AutoRun()
     
    ThisWorkbook.Save

    Application.OnTime Now + TimeValue("00:03:00"), "AutoRun"
     
End Sub

Change the 3 in "00:03:00" to however many minutes you want between the auto-saves. Then, just make sure to run the macro once to get it started.

hope this helps


*moved to the programming forum