workbook_Open

[Guest]

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

 

[Guest]

How about:

Private Sub Workbook_Open()
ActiveWorkbook.ConflictResolution = xlOtherSessionChanges
End Sub

 

[Guest]

Hi,

Thanks for responding. I tried what you suggested but unfortunately i get
the same error message:

Run-time error '1004'
Application-defined or object-defined error

Any other suggestions?

Ernie
Thanks

 

[NickHK]

The workbook is shared ?

There was a recent post regarding this. I did a quick test in XL2002 and
this setting (xlOtherSessionChanges) always fails for me.
As there is no way to set this manually, maybe MS forgot to implement it,
but the enum exists.

NickHK