Hello there. I have the following code in a worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("C63")) Is Nothing Then
Application.Run "Calculate_Stamp_Duty_NEW_HOME"
End If

If Not Intersect(Target, Range("D9")) Is Nothing Then
Application.Run "Calculate_Stamp_Duty_PROPERTY_3"
End If

End Sub

The first "IF" statement works perfectly because cell C63 is a cell that I
manually type a new value into. The second "IF" doesn't work. The cell D9
gets it's value automatically from another workbook. What I want to happen is
for the macro "Calculate_Stamp_Duty_PROPERTY_3" to run automatically
when the value in the other workbook is changed (manually, and therefore the
value of D9 is updated automatically in this workbook).

Can someone give me some advice please?
Regards, Brett