Workbook.AutoSaveOn (Excel)

True if the edits in the workbook are automatically saved.

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.

ActiveWorkbook.AutoSaveOn = True