Hide then show specific column

[littleandyjai]

I have a workbook with columns A:ET each with a title at the top, I want to create a new workbook like an index where I can hide all the data then select only specific individual columns that I need to work on. I can kind of get it to work but it means creating buttons against each heading and another button to hide all.....is there a better way to do this particularly with tick boxes?

[JBeaucaire]

Yes, there's ways to do just about anything.

Click GO ADVANCED and use the paperclip icon to post up your workbook. Make sure it's clear where you want assistance in the workbook.

[littleandyjai]

I cant post the original document but have recreated an idea of what I have done, first I have used a macro to hide all columns from the range A:ET. Then I hit the button of the individual colums I want to view. What would look better is if it was a column of tick boxes. I understand in the properties there is a value of checked or unchecked but Im not a VB guru so dont know what is the best option to scan the colum of ticks and only select the checked ones!

[martindwilson]

you need so save that as xlsm or xls for the macros to show

[WHER]

Maybe use a spinbutton to selectively unhide some columns (one at a time), see attachment.