You're going to have to create an application level event handler.

http://support.microsoft.com/default...66&Product=xlw

--
Jim Rech
Excel MVP
"Erich Neuwirth" wrote in message
...
|I need to write an addin which contains a class module.
| Each class instance will have a range as one of its properties,
| and these ranges will come from other workbooks, not from the addin.
| The object will need to run a method (aka subroutine)
| when a cell in the associated range changes.
| How can I acomplish that, with an On_Change event
| or with another technique?
| It will probably not be possible to add code
| to the workbook containing the range, all code should be in the addin.
|
|