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?


Private Sub Worksheet_Change(ByVal Target As Range)

    'my code'
    Stop 'show me if event is working

End Sub

Thanks,