Stop macro that keeps firing

Can someone help with this?

I have a button attached to a macro that works fine, if I click it manually it does exactly as I want.

I have just tried to activate this macro from the worksheet, as shown

HTML Code: 

I have J1 cell showing 0 then when I change it to 1 it starts the marco and continues to activate it which is messing everything up.
How would I edit this so that 0 does nothing then when the value changes from 0 the macro fires once and then fires again when the value changes again.

Thanks

Difficult to say without knowing what's in the called macro, but I think it's running over and over because the called macro changes the sheet and that sets it off again.
If that's the case, try this.

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    If Range("J1") = 1 Then Call Recording_macro
    Application.EnableEvents = True
End Sub

BSB

BSB that has worked fine, many thanks.
When the value gets changed to 1 from any other number it kicks in the macro only once.
How could I edit again so that the macro kicks in on any value change?

Maybe this?

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    If Not Intersect(Range("J1"), Target) Is Nothing Then Call Recording_macro
    Application.EnableEvents = True
End Sub

BSB

Spot on.
Thank you

No problem. Happy to help

BSB