Why "Worksheet_Change" dont work under DDE link?

[Guest]

Worksheet_Change work correct (it appears), if I change cell content
manually. But if the contents is changed by means of DDE, Excel does not see
this change (the event does not appear). What to do?
The Answer to get in russian advisable.

 

[Frank Kabel]

Hi
the change event is not triggered by this. One possible workaround:
- create a formula which references your DDE linkes cell. e.g.
=A1
- use the worksheet_calculate event

 

[Tom Ogilvy]

I believe Change is fired in xl2000 or later for a DDE link. It was only in
xl97 that it didn't work.

for DDE links you can use
SetLinkOnData - a property of the Workbook.