Hi
use the worksheet_calculate event in this case

--
Regards
Frank Kabel
Frankfurt, Germany


David Jenkins wrote:
Hi,

I have 2 workbooks, WB1 and WB2. WB1 contains a link to
WB2, e.g., A1 on sheet1 in WB1 is linked to A1 on sheet1
in WB2. I would like to run some code when the cell WB1.A1
changes as a result of WB2.A1 changing, but neither of the
events mentioned fire when A1 in WB2 changes, even tho the
value in WB1 does change. VBA Help, under "SheetChange
Event" says "Occurs when cells in any worksheet are
changed by the user or by an external link." I would have
thought this qualifies as "an external link", but maybe
not? Anyway, if anyone can tell me how to make this work,
I'd appreciate it.

Thanks in advance

David Jenkins