VBA Script will not stop running
I have a script to clear checkboxes in a range and it works perfectly, except it will not stop. After it runs I want to be able to use the checkboxes again for calculations, then run the macro to clear them, then reuse the boxes as needed. As it is written it continues to run rendering the checkboxes useless. As soon as I check one it immediately returns to unchecked.
Can someone offer some guidance on how to run the script once, then end. I really hate to be relegated to Google just because of this one function.
Here is my script:
Sub ClearBoxes()
'
' ClearBoxes3 Macro
' Created by Tim Woolley on Saturday, April 24, 2021 4:24:28 PM
'
Range("J5:J20").Value=false
Range("L5:L20").Value=false
End Sub
Thanks in advance.