B
BLarche
Hey everyone. I am new to this board to bear with me if my question is
not detailed enough. I have several columns of data in my worksheet,
all with column headers ranging from January - Decemeber. I have
created some checkboxes with the names of January - December as well.
I want to create a macro for each checkbox (12 subs) that will
hide/unhide any column with that corresponding name in the header. For
instance, when I check the January checkbox, I want it to hide or
unhide, depending on the state of that column, all columns with the
header of January. All column headings are in row 9, so I will just
need to check row 9 in every column of my worksheet for the
corresponding heading.
Does anyone have any solutions for me?
not detailed enough. I have several columns of data in my worksheet,
all with column headers ranging from January - Decemeber. I have
created some checkboxes with the names of January - December as well.
I want to create a macro for each checkbox (12 subs) that will
hide/unhide any column with that corresponding name in the header. For
instance, when I check the January checkbox, I want it to hide or
unhide, depending on the state of that column, all columns with the
header of January. All column headings are in row 9, so I will just
need to check row 9 in every column of my worksheet for the
corresponding heading.
Does anyone have any solutions for me?