Workbook.ConflictResolution Property (Excel)
Returns or sets the way conflicts are to be resolved whenever a shared workbook is updated. Read/write XlSaveConflictResolution.
Syntax
expression .ConflictResolution
expression A variable that represents a Workbook object.
Remarks
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. |
Example
This example causes the local user's changes to be accepted whenever there’s a conflict in the shared workbook.
ActiveWorkbook.ConflictResolution = xlLocalSessionChanges