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