Stop macro that keeps firing

[parbynat]

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

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

[BadlySpelledBuoy]

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.

Please Login or Register  to view this content.

BSB

[parbynat]

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?

[BadlySpelledBuoy]

Maybe this?

Please Login or Register  to view this content.

BSB

[parbynat]

Spot on.
Thank you

[BadlySpelledBuoy]

No problem. Happy to help

BSB