Worksheet change
This often doesn't trigger the change event.
You could try the calculate event.
--
HTH
Bob Phillips
"CraigB" wrote in message
...
I'm trying to use the worksheet change function to start a macro. I'm
monitoring a cell which is linked to an external source. When that cell
changes, it should start the macro, but nothing happens.
If I start the macro by manually changing the cell myself then the the
macro
works properly, but I want it to start automatically when the linked cell
changes. Any ideas.
Thanks in advance,
Craig.
|