Hi Lmg,

I am trying to enable a marco when a cell = a value. the cell is
linked to DDE and changes values with a remote device.

There are (at least) three alternatives; which one to use will depend
on what you want the macro to do:

1. Use Application.OnData to run a macro every time a DDE link is
updated (See Online help for examples)

2. Use a user-defined-function, called when the cell equals the value,
but that's limited in what it can do.

3. Use the Worksheet_Calculate event to check the cell's value

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk