I am creating a checklist of items where each applicable item needs to be checked off. Based on the "Instructions" tab, I have created a macro that automatically hides certain rows of the checklist (on the "Questionnaire" tab) based on certain criteria. Here is the code for that macro:

PHP Code: 
Private Sub Worksheet_Change(ByVal Target As Range) 'on the worksheet change
Dim LR As String, c As Range    'declare variables

Select Case Target.Address  'if the cell changed location is...

    Case "$D$11"   'cell D11 then...
        With Sheets("Questionnaire")
            LR = .Range("S6555").End(xlUp).Row   'set LR to the last row in column S that contains a value
                For Each c In .Range("S1:S" & LR).Cells  'loop through each cell in column S from row 1 to LR
                    If c.Value = "HIDE" Then    'if the value in the current cell in the loop is equal to "HIDE"
                        c.RowHeight = 0 'then hide the row
                    End If
                Next c  'move to next cell in the loop
        End With
        
End Select

End Sub 
The problem that I am having is that when rows are hidden from this macro, the related checkboxes are not hidden (I assume because they are objects on the spreadsheet). Is there a way to hide the checkbox on each row that is hidden - either by alterning the macro or some other means?