ConflictResolution Property
Returns or sets the way conflicts are to be resolved whenever a shared workbook is updated. Read/write XlSaveConflictResolution.
| XlSaveConflictResolution can be one of these XlSaveConflictResolution constants. |
| xlLocalSessionChanges. The local user's changes are always accepted. |
| xlOtherSessionChanges. The local user's changes are always rejected. |
| xlUserResolution. A dialog box asks the user to resolve the conflict. |
expression.ConflictResolution
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example causes the local user's changes to be accepted whenever there’s a conflict in the shared workbook.
ActiveWorkbook.ConflictResolution = xlLocalSessionChanges