I have tabs that already have grouping assigned to certain columns. I would like to create two macro buttons, one that will go through each tab and group, and another that will ungroup. Each tab has multiple groups of columns that are grouped.
The purpose is so that when a user prints a workbook, they can decide easily/quickly whether they want to print the grouped columns. Currently they are forced to go through each tab individually and hit the "+" or "-" buttons above the grouped columns.
Ideally the macro would go through each tab and hit the "1" or "2" buttons for grouping.
The purpose is so that when a user prints a workbook, they can decide easily/quickly whether they want to print the grouped columns. Currently they are forced to go through each tab individually and hit the "+" or "-" buttons above the grouped columns.
Ideally the macro would go through each tab and hit the "1" or "2" buttons for grouping.
Last edited:
