Hide checkbox when rows are hidden

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?

The problem is they way the macro for hiding the rows is set up now - it's based on a value in each row (column S). I could change the macro to specifically hide the rows I need hidden (there are two different options, each of which hides a few rows). Would that be the best way to go about it?

How would I modify the original macro to take this into consideration? For instance, if the drop down menu on the "Menu" tab ($D$11) is set to equal one way (let's call it "Option 1"), then I would want rows 50-52 to be hidden on the "Questionnaire" tab. If the menu is "Option 2", then I need row 18 to be hidden.

I'm sorry for being a bit difficult here, but I'm not sure how to get this into the code. How would you insert this into the code I included above?

I haven't been able to get this to work after trying several difference tolerance levels. I went through and names each checkbox based on the checklist item. If the input on the "Instructions" tab is Option 1, then row 18 is hidden, which corresponds to Check Box 7. If the input on the "Instructions" tab is Option 2, then rows 50-52 are hidden, which corresponds to Check Box 18a and Check Box 18b. Would it be easier to build the specific items that need to be hidden into the macro based on their name?

Also, can you explain what the O.Top and c.Top is doing in this formula?

The check boxes still aren't hiding on mine - are they hiding on the one you are looking at?

Do I need to format the shapes differently? Right now, I have them as basically the same height as the cell, so I wasn't sure if that was causing a problem. I tried shrinking these down some, but it didn't seem to matter.

Also, if there is an easier way to do this, I am open to that as well. I just need the checkboxes to be the inputs for people completing the checklist.

Thanks.

From the little I understand about macros, it matters what the actual "input" cell is for how the code should be written. For instance, I have columns P and Q set up as a formula to display "HIDE" based on what option is picked on the first tab. However, when you change the formula to the hard-keyed text "HIDE", it changes where the input is located. Will this affect how the code is written? I need the rows to hide based on the change made on the first tab, not typing into the cells in columns P and Q, as these will be hidden once the checklist is complete.

There are formulas in Cells Q18 and P50-52 on the file I attached. These are the only rows that may be hidden - the rest will all be visible no matter what option you choose from the drop-down menu.

No - when I choose ABC on the Instructions tab, it hides the rows properly but does not hide the checkbox.

I'm not getting any of the rows to hide in this file.

Where do you see "ClientTypeConsiderations" in the file?

As a side note, I just wanted to thank you for helping me out on this. I know it's been a bit of a pain going back and forth like this, but I appreciate your help.

I don't know why, but I can't find the code you showed above.

Here is the code I see on the "Instructions" tab:

Please Login or Register  to view this content.

And here is the code I see on the "Questionnaire" tab:

Please Login or Register  to view this content.

Can you tell me which tab you see the Client Type Considerations on?

OK - found what you were referring to. I think this was related to a macro from a workbook this was was rolled forward from. None of the recorded macros should be applied to this workbook though.

As such, these macros should be deleted from this workbook, as they won't be necessary. The only macros I will need for this one is hiding/unhiding the rows and checkboxes on the Questionnaire tab. I was having some trouble getting rid of the unnecessary macros through, as Excel kept crashing when I tried to delete them. I'm not sure what that's about.

Thanks.

It looks like after the macro was run, the checkboxes disappeared for good. If possible, I would like them to reappear if you switch from ABC to XYZ and vice versa. I cannot see checkbox 7, checkbox 18a or checbox 18b in the spreadsheet attached.

This fixes the issue of the boxes not reappearing and it looks like the rows are properly unhidden when you change options from one to the other.

However, I am still having trouble getting the boxes to hide now. Is it still working for you?

When I open up that file, I can't see the first checkbox that is supposed to be hidden. Then when I choose the other option, that checkbox goes away as well. The rows are hiding and unhiding correctly, but it doesn't look like the boxes are.