Activate/deactivate checkboxes using a macro, when those checkboxes have also macros assigned

MrPet88 

Use ActiveX check boxes instead of Form Control check boxes.

All code then goes into the worksheet module:

Private Sub CheckBox1_Click()
    Range("C:C").EntireColumn.Hidden = Not Me.CheckBox1
End Sub

Private Sub CheckBox2_Click()
    Range("D:D").EntireColumn.Hidden = Not Me.CheckBox2
End Sub

Private Sub CommandButton1_Click()
    Dim ctl As OLEObject
    For Each ctl In Me.OLEObjects
        If TypeName(ctl.Object) = "CheckBox" Then
            ctl.Object.Value = True
        End If
    Next ctl
End Sub

Private Sub CommandButton2_Click()
    Dim ctl As OLEObject
    For Each ctl In Me.OLEObjects
        If TypeName(ctl.Object) = "CheckBox" Then
            ctl.Object.Value = False
        End If
    Next ctl
End Sub