Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook_sheetChange event | Excel Programming | |||
workbook_sheetchange | Excel Programming | |||
Workbook_SheetChange will not fire | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |