Why "Worksheet_Change" dont work under DDE link?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
Back
Top