Workbook.AutoSaveOn property (Excel)

True if the edits in the workbook are automatically saved. Read/write Boolean.

Syntax

expression.AutoSaveOn

expression A variable that represents a Workbook object.

Remarks

When a new workbook is created, the default value for the AutoSaveOn property is False, the property is disabled, and the user's changes will need to be saved manually. However, if the workbook is hosted in the cloud (that is, OneDrive, OneDrive for Business, or SharePoint Online), the AutoSaveOn property defaults to True and the edits in the specified workbook are automatically saved. If a cloud-hosted workbook is shared with other users, their changes will also be automatically merged into the user's local copy when AutoSaveOn is True.

The following table shows examples of AutoSaveOn behavior.

AutoSaveOn toggle state Set AutoSaveOn to True Set AutoSaveOn to False
AutoSaveOn == True No-op AutoSaveOn turned off
AutoSaveOn == False AutoSaveOn turned on No-op
Disabled Error Error

For more information about AutoSave, see How AutoSave impacts add-ins and macros.

Example

This example notifies you whether the workbook is set to be automatically saved.

Sub UseAutoSaveOn()
    MsgBox "This workbook is being saved automatically: " & ActiveWorkbook.AutoSaveOn
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.