LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Worksheet_Change and Workbook_SheetChange not firing

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook_sheetChange event J S Excel Programming 0 August 9th 04 07:16 PM
workbook_sheetchange JulieD Excel Programming 1 June 14th 04 04:32 AM
Workbook_SheetChange will not fire Robert Willard Excel Programming 1 September 10th 03 07:52 PM
worksheet_change vs. calculate, and worksheet_change not running Tom Ogilvy Excel Programming 1 July 14th 03 02:51 AM
worksheet_change vs. calculate, and worksheet_change not running Ross[_5_] Excel Programming 0 July 13th 03 04:27 PM


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"