共用方式為


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 

請參閱

概念

Workbook Object

Workbook Object Members