Worksheet_Change DDE

[Johan de Kok]

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

 

[Don Guillett]

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

 

[Tom Ogilvy]

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