I have a code that is activated when a cell if modify inside a Range. When I refresh all connections, the code is activated and runs an error.

I need the code to not start when refreshing all connections or any connection at all.

The code is this:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Target.Worksheet.Range("H5")) Is Nothing Then Macro

End Sub

I need the code to not start when connections are refreshing.