Below is the VBA help. I you right click the VBA window and select object
browser. the in the search box put in ConflictResolution you will find the
options you are looking for are part of XlSaveConflictResolution




ConflictResolution Property
See Also Applies To Example Specifics
Returns or sets the way conflicts are to be resolved whenever a shared
workbook is updated. Read/write 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 theres
a conflict in the shared workbook.

ActiveWorkbook.ConflictResolution = xlLocalSessionChanges



"Joel Crasto" wrote:

Hi,

Could anyone help me with the option xlOtherSessionChanges.
I tried whatever options I could think of but could not find a solution.

I initially used the following syntax
"ActiveWorkbook.ConflictResolution = xlOtherSessionChanges"
but this gives me a run time error - 1004, method conflict resolution of
the object workbook failed.

Presently I am using "ActiveWorkbook.ConflictResolution = xlUserResolution"
but this requires me to trust the users to choose "Accept others changes"
whenever there is a conflict.

Could anyone suggest a solution or did Microsoft just forget to enable this
function.

Thanks in advance
Joel