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 |
|---|
|
See Also