How about:

Private Sub Workbook_Open()
ActiveWorkbook.ConflictResolution = xlOtherSessionChanges
End Sub
--
Gary''s Student - gsnu200728


"ernie" wrote:

I need help with this code

I get the error message "runtime error '1004'"

Private Sub Workbook_Open()
ConflictResolution = xlOtherSessionChanges
End Sub

When i try to set the option manually from the thisworkbook property field i
get the error message "Invalid Property Value". Can some please help me with
this situation? Are there any alternatives to turn to??

thanks in advance
Ernie