Worksheet change event for linked value

[roli001]

Hi,

I have an Excel spreadsheet, which is linked to an application feeding it live Forex numbers. The feed is working great as every time a price changes, it updates my sheet automatically. The problem is that I would like to activate a code any time a value changes on sheet1 but the worksheet_change event doesn't seem to recognize the changes.

I've ironed it down to the fact that if a sheet has links on a sheet (DDE, Web, other sheets, etc) and the values change (links stay the same) then the worksheet_change event doesn't recognize the change
When I change a value in any cell manually then the event works but it doesn't work for a linked cell value change.

I'd really appreciate some help in solving this. Work around?

Please Login or Register  to view this content.

Thanks,

[mrice]

Have you tried the Worksheet_Calculate event instead. It's a bit of a long shot but it's worth a try.

[roli001]

Have you tried the Worksheet_Calculate event instead. It's a bit of a long shot but it's worth a try.

Thanks mrice. That did the trick.