Hi all,
Using Excel 2003 VB
Currently I have 3 toggle buttons which, independantly, on selection hide a set of columns and se-selection unhide the same set ofcolumns (not Unhide all). On selection of 2 or all 3 buttons thier associated sets of columns hide, thus if all 3 buttons are selected together I have very few visible columns.
The issue occurs when I de-select the buttons because some of the associated sets of columns overlap each other. therefore when I de-select a button, it unhides its associated columns even the columns selected to be hidden by a selected button.
Is it possible to, on de-selection of a toggle button, get it to check what other toggle buttons are selected and essentially re-run their macros
OR
only unhide the columns not associated to another button in its selected condition?
Many Thanks
Using Excel 2003 VB
Currently I have 3 toggle buttons which, independantly, on selection hide a set of columns and se-selection unhide the same set ofcolumns (not Unhide all). On selection of 2 or all 3 buttons thier associated sets of columns hide, thus if all 3 buttons are selected together I have very few visible columns.
The issue occurs when I de-select the buttons because some of the associated sets of columns overlap each other. therefore when I de-select a button, it unhides its associated columns even the columns selected to be hidden by a selected button.
Is it possible to, on de-selection of a toggle button, get it to check what other toggle buttons are selected and essentially re-run their macros
OR
only unhide the columns not associated to another button in its selected condition?
Many Thanks