How to clear all checkbox to False in Google Sheet

[Excelpromax123]

Hi everyone. I have 1000 lines of checkboxes inserted, After checking for a while, I want the checkboxes to be false, what should I do. Thank you

 

[Sparcot]

Hello. Adjust sheet name ("Sheet1") if needed and the quantity of checkboxes ("1000"). If not all of them are checked / unchecked in result - raise the number, let's say to 1500

Sub Check_All()
    On Error Resume Next
    For x = 1 To 1000
        Sheet1.CheckBoxes("Check Box " & x).Value = True
    Next x
End Sub

Sub Uncheck_All()
    On Error Resume Next
    For x = 1 To 1000
        Sheet1.CheckBoxes("Check Box " & x).Value = False
    Next x
End Sub