VBA - WorkSheet Change ByVal Target As Range and DDE link

Question

Hi, I´ll be gratefull if someone could help with this problem; when the value of a cell changes, do something, but my macro is not working when the value is related with the value of a cell of DDE link.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    
Dim KeyCells As Range

Set KeyCells = Sheets("Sheet1").Cells(1, 1)

If Cells(1, 1) <> Sheets("Sheet1").Cells(1, 2) Then

Sheets("Sheet1").Cells(1, 2) = Sheets("Sheet1").Cells(1, 1)

MsgBox "Cell" & Target.Address & "has changed."
    
End If
    
End Sub