Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

This sub is only triggered by changing cells in the worksheets, not changes
caused by een external link i.e. DDE.

Any Idea

Johan de Kok

try using _calculate instead and put =now() somewhere on the worksheet

--
Don Guillett
SalesAid Software

"Johan de Kok" wrote in message
...
Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

This sub is only triggered by changing cells in the worksheets, not
changes
caused by een external link i.e. DDE.

Any Idea

Johan de Kok

In xl2000 and later, it should be triggered by DDE. Are you using xl97?

--
Regards,
Tom Ogilvy

"Johan de Kok" wrote in message
...
Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

This sub is only triggered by changing cells in the worksheets, not
changes
caused by een external link i.e. DDE.

Any Idea

Johan de Kok