Share via


Workbook.ConflictResolution Property

Excel Developer Reference

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.

Visual Basic for Applications
  ActiveWorkbook.ConflictResolution = xlLocalSessionChanges

See Also