View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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.