I am creating a worksheet for my employer that has many ActiveX checkboxes that when checked unhide rows which contain text boxes or other checkboxes. My frustration has been that the rows that have additional checkboxes are hiding the row but the checkbox is still visible. I have tried multiple solutions including (but not limited to) selecting the "move but don't size" in format controls, grouping the checkboxes and selecting the "move but don't size" and also tried some code that I had found, to no avail.

Note: I am fairly new to VBA codes but have been learning quickly so if there are other things wrong with the codes I have written below or if it somehow is affecting the whole functionality of my sheet let me know. Im VERY grateful for the help!!!

This is the first set of code I used to try and hide the checkboxes:

Sub Hide_other_elec()
     
    Rows("A110:A129:Q110:Q129").Hidden = False
     
     'ActiveSheet.CheckBoxes.Visible = True
     'OR
    Dim objOLE As OLEObject
     
    For Each objOLE In ActiveSheet.OLEObjects
        If objOLE.progID = "Forms.CheckBox.1" Then
            objOLE.Visible = True '/False
        End If
    Next objOLE
     
End Sub
And the second:

Private Sub CheckBox12_Click()
    If CheckBox12.Value Then
        Range("A110:A129:Q110:Q129").EntireRow.Hidden = False
        ActiveSheet.CheckBoxes("Check Box 27").Visible = True
        ActiveSheet.CheckBoxes("Check Box 28").Visible = True
        ActiveSheet.CheckBoxes("Check Box 29").Visible = True
    Else
        Range("A110:A129:Q110:Q129").EntireRow.Hidden = True
        ActiveSheet.CheckBoxes("Check Box 27").Visible = False
        ActiveSheet.CheckBoxes("Check Box 28").Visible = False
        ActiveSheet.CheckBoxes("Check Box 29").Visible = False
    End If
End Sub