software

Hi,

I want to trigger a script whenever the data changes in a cell.
For testing purposes I used this little script:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range(quot;c1quot;)) Is Nothing Then
Range(quot;a1quot;) = 123
End If
End Sub

The problem:
If I type something in c1 everything goes ok
But when I put this =[Book3]Sheet1!$A$1 in c1 and work tru a link and
change cell a1 in book 3 nothing happens.

How can I trigger the script thru a link that changes?

Thanks--
climax
------------------------------------------------------------------------
climax's Profile: www.excelforum.com/member.php...oamp;userid=30816
View this thread: www.excelforum.com/showthread...hreadid=507503You'll want to use a different event. _change is when you type something in.
Maybe you can use worksheet_calculate?

climax wrote:
gt;
gt; Hi,
gt;
gt; I want to trigger a script whenever the data changes in a cell.
gt; For testing purposes I used this little script:
gt;
gt; Private Sub Worksheet_Change(ByVal Target As Range)
gt; If Not Intersect(Target, Range(quot;c1quot;)) Is Nothing Then
gt; Range(quot;a1quot;) = 123
gt; End If
gt; End Sub
gt;
gt; The problem:
gt; If I type something in c1 everything goes ok
gt; But when I put this =[Book3]Sheet1!$A$1 in c1 and work tru a link and
gt; change cell a1 in book 3 nothing happens.
gt;
gt; How can I trigger the script thru a link that changes?
gt;
gt; Thanks
gt;
gt; --
gt; climax
gt; ------------------------------------------------------------------------
gt; climax's Profile: www.excelforum.com/member.php...oamp;userid=30816
gt; View this thread: www.excelforum.com/showthread...hreadid=507503

--

Dave Peterson