ConflictResolution Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | Workbook Object