worksheet change and DDE

[Pluut]

I try to use the Worksheet change event. But the cell, which one I want to look if it will change, changes as a result of an extern source (I guess that's a DDE). But then the worksheet change function doesn't work anymore. Does anybody know an alternative

Thank tou, Pluut

[Gary''s Student]

Try:

Application.OnData "your_macro_name"
--
Gary''s Student


"Pluut" wrote:

>
> I try to use the Worksheet change event. But the cell, which one I want
> to look if it will change, changes as a result of an extern source (I
> guess that's a DDE). But then the worksheet change function doesn't
> work anymore. Does anybody know an alternative
>
> Thank tou, Pluut
>
>
> --
> Pluut
> ------------------------------------------------------------------------
> Pluut's Profile: http://www.excelforum.com/member.php...o&userid=37236
> View this thread: http://www.excelforum.com/showthread...hreadid=574192
>
>

[NickHK]

DDE does not fire the _Change event (apparently).
You can use ThisWorkbook.SetLinkOnData
DDE does fire the _Calculate event as needed though.

Never used DDE, just what I've read.

NickHK

"Pluut" <[email protected]> ¼¶¼g©ó¶l¥ó·s»D:[email protected]...
>
> I try to use the Worksheet change event. But the cell, which one I want
> to look if it will change, changes as a result of an extern source (I
> guess that's a DDE). But then the worksheet change function doesn't
> work anymore. Does anybody know an alternative
>
> Thank tou, Pluut
>
>
> --
> Pluut
> ------------------------------------------------------------------------
> Pluut's Profile:
> http://www.excelforum.com/member.php...o&userid=37236
> View this thread: http://www.excelforum.com/showthread...hreadid=574192
>