Macro won't fire on sheet change with query refresh

This is my code, a query refresh changes the values on the screen which I want to trigger the macro but it doesn't?


Private Sub Worksheet_Change(ByVal Target As Range)
If Range("AA7") <> Range("AA8") And Range("E2") = "ON" Then

Run ("MACRO1")


Else
Exit Sub
End If
End Sub

Code worked for me. Did you put it in the sheet module?

yes its in the sheet module, and it will work if you manually make a change but i need it to change with a refresh and no manual user input