Vba code to hide specific cells

Hi

Your solution was worked partially, the thing now is that when not toggled, the Main category button already deploy the Sub categories buttons, when the desire is to show the Sub categories only when toggling the Main Categories. Here´s the "ideal sequence":

1. When not toggled, the only thing appearing in screen are the 4 Main Categories buttons (Body, Chassis, Electrical & Powertrain).

2 When toggling a certain Main Category button, the cells to appear have to be only the Sub Categories buttons. (Taking as an example the Electrical, the only cells that must appear when toggling are rows 134,150,163).

Your solution has already helped me a lot! Just wondering what change must be applied to you code in order to have the desired sequence...

Originally Posted by rollis13

Just a hint, it might work. Try splitting row ranges and skip subcategory rows; here's the example for the main category POWERTRAIN:

Sub TogglePowertrain()
    With Worksheets("Codes")
        .Rows("175:188").Hidden = Not .Rows("175:188").Hidden
        .Rows("190:216").Hidden = Not .Rows("190:216").Hidden
    End With
End Sub

---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Hi

Your solution was worked partially, the thing now is that when not toggled, the Main category button already deploy the Sub categories buttons, when the desire is to show the Sub categories only when toggling the Main Categories. Here´s the "ideal sequence":

1. When not toggled, the only thing appearing in screen are the 4 Main Categories buttons (Body, Chassis, Electrical & Powertrain).

2 When toggling a certain Main Category button, the cells to appear have to be only the Sub Categories buttons. (Taking as an example the Electrical, the only cells that must appear when toggling are rows 134,150,163).

Your solution has already helped me a lot! Just wondering what change must be applied to you code in order to have the desired sequence...