ConflictResolution Property

Applies To

Workbook object.

Description

Returns or sets the way conflicts are to be resolved whenever a shared workbook is updated. Read/write Long.

Can be one of the following XlSaveConflictResolution constants.

Constant

Description

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