How do you handle errors from another workbook?

[dmasters4919]

If I have a macro that's changing the value of another workbook, and that triggers a Worksheet change event which then causes an error, my original macro stops regardless of whether or not I have used 'On Error Resume Next'. Is there a way to handle these errors?

Thanks!

[TMS]

Switch off event handling before you change the other workbook.

Or, if the other workbook needs to execute the change event handler code, you need to fix the error handling in the other workbook so it doesn't crash your code.

.... and that triggers a Worksheet change event which then causes an error

How does it trigger an error? What error does it trigger? Why doesn't your error handling cope with it?

Regards, TMS