Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
CELL("filename") doesn't work on shortcut workbook link? | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
How do I make a "Worksheet_Change event" to show any changes to cells? | Excel Worksheet Functions | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) |