Hi all,
I've set up a large number of checkboxes and coded a "master checkbox" to select them or unselect them all. Each individual checkbox is assigned a macro that will hide a certain number of rows on another sheet. This macro works fine when I individually click on each checkbox, but the macro will not run when selected via the master checkbox. I'd appreciate any insight you could offer.
Here is my code so far:
For the select all checkbox:
The Hiderows Macro - This is set to hide a certain number of rows on a sheet based on the checkbox output cell in another sheet.
Individual Checkbox Macro - calls HideRows and assigns interaction with Select All Checkbox (allows selection/deselection of individual checkboxes while master is checked)
Namely, I want to be able to click the master checkbox and execute the HideRows macro across all checkboxes, and vice versa. Any help greatly appreciated.
Bookmarks