Using code:
If Not Application.IntersectRangerng_trigger, Target Is Nothing Then

it sees it as Nothing and skips to Else:

To be clear, Rangerng_trigger is not the active cell,
another change in the worksheet causes Rangerng_trigger to change value,
only when the value changes in the named range should it trigger macro to run.