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.