Need VBA to hide columns based on text in a particular row

[jdp949]

I am trying to create a series of checkboxes on one worksheet "Selections" that hide rows on another worksheet, "Data Table" when checked so that the Chart on "chart" worksheet only shows the series of data that I want it to show.
I have accomplished this with the simple VBA of:

Please Login or Register  to view this content.

I attached this code to all 50 or so selection buttons that correspond to different columns in worksheet "Data Table".
I also added a Select All button and Clear All button that work well.
My problem is that if I add a column (new data series) to worksheet "Data Table" all of my checkboxes now point to the wrong column.
So I was trying to figure out what VBA I should use so that it looks in worksheet "Data Table" in row 2 for specific text and then hides the column or columns that match that text.

Any thoughts?

Thank you.

[Mumps1]

Try:

Please Login or Register  to view this content.

[jdp949]

Thanks Mumps1 for the suggested VBA. This is what I found when I used it.
When the checkbox was unchecked it hid the correct column but on the wrong worksheet. The column was hidden from the "Selections" worksheet rather than the "Data Table" worksheet. Also, when the checkbox was rechecked the column didn't unhide. If I then manually unhide the row, when I recheck the box, it hides it again, even though I need that row to hide when unchecked, and unhidden when checked.

Any other thoughts?

[Mumps1]

Could you attach a copy of your file? It would be easier to see how you data is organized and to test possible solutions.* Include a detailed explanation of what you want to do using a few examples from your data and referring to specific cells, sheets and workbooks.* De-sensitize the data if necessary.