ConflictResolution Property

Microsoft Excel Visual Basic

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