Why "Worksheet_Change" dont work under DDE link?
 

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.

Why "Worksheet_Change" dont work under DDE link?
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Goguladze" schrieb im
Newsbeitrag ...
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.

Why "Worksheet_Change" dont work under DDE link?
 

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.

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
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

--
Regards
Frank Kabel
Frankfurt, Germany

"Goguladze" schrieb im
Newsbeitrag ...
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.