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.

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.
|
|