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