Syntax

expression.AutoUpdateSaveChanges

expression A variable that represents a Workbook object.

Remarks

The property must be set to a value from 5 to 1440 for this property to take effect.

Example

This example causes changes to the shared workbook to be posted to other users whenever the workbook is automatically updated.

Visual Basic for Applications
ActiveWorkbook.AutoUpdateSaveChanges = True
auto update save changes Auto Update Save Changes Property Automatically post changes by end user to other users? autoupdatesave AutoUpdateSaveChanges AutoUpdateSaveChanges Property Prevent current changes from altering other shared workbooks? Reflect my changes in other workbooks? Update all shared workbooks with current changes?

See also: