Uncheck all checkboxes across entire workbook via CommandButton
This code iterates through all sheets (except sheets named Sheet100 and OtherSheet) and unchecks all your ActiveX checkboxes named CheckBox1 Sub uncheck_boxes() Dim ws As Worksheet Dim xbox As OLEObject For Each ws In ThisWorkbook.Worksheets If ws.Name <> “Sheet100” And ws.Name <> “OtherSheet” Then For Each xbox In ws.OLEObjects ws.OLEObjects(“CheckBox1”).Object.Value = False Next End If … Read more