| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Workbook.AutoUpdateSaveChanges property (Excel) |
vbaxl10.chm199079 |
|
|
06f9951d-a17a-bf88-4f6e-65835eb112f8 |
05/25/2019 |
medium |
True if current changes to the shared workbook are posted to other users whenever the workbook is automatically updated. False if changes aren't posted (this workbook is still synchronized with changes made by other users). The default value is True. Read/write Boolean.
expression.AutoUpdateSaveChanges
expression A variable that represents a Workbook object.
The AutoUpdateFrequency property must be set to a value from 5 to 1440 for this property to take effect.
This example causes changes to the shared workbook to be posted to other users whenever the workbook is automatically updated.
ActiveWorkbook.AutoUpdateSaveChanges = True[!includeSupport and feedback]