Vba code to hide specific cells

Hi everyone

I´m constructing the file attached in order to have my workshop processes simplified. I´ve applied VBA coding to the cells where Main Categories (deep blue) and Subcategories (light blue) are placed (I have inserted button and then applied macros to them) so that the desired result is that they hide the cells with the range specified.

However I´m having trouble when clicking on Main Categories buttons (the four big-blue ones) because all cells of the category deploy, when in reality what shoud be is that only the Subcategories buttons are deployed (like in the attached image), so then its the user the one that decides which Sucategory to deploy.

Is there a way to change the code I applied in order to get this desired effect?

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:

Please Login or Register  to view this content.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------
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

Try with these other tweaks (example for POWERTRAIN):

Please Login or Register  to view this content.

and these others respectively modified as follows:

Please Login or Register  to view this content.

--------------------------------------------------------------------------------------------------------------------------------------------

Thanks a lot! I´ve applied to all respective cells and now the whole file is toggling as desired. Much appreciated.

I propose another solution that does not refer to specific row numbers. It analyzes the colors of the shapes (and cells).
To use it, you need to "clean up" a bit first by running the ArrangeShapes procedure once. The same macro is assigned to all shapes in the 15:200 row range. You will be able to discard all the modules you have had in the project so far.
If the category ranges change in the future, just run the ArrangeShapes procedure once again.

Artik