Hi
I have a spreadsheet with over 200 columns and I want to use VBA to hide selected ones. On a separate worksheet, I have put Activex checkboxes going down in a column next to the column names. This works fine, but what I would like to do is have several columns like this so that I can effectively have different default views for different users and use an option button at the top of each column to select which set of checkboxes are used.
Any help with this would be much appreciated.
Thanks!
I have a spreadsheet with over 200 columns and I want to use VBA to hide selected ones. On a separate worksheet, I have put Activex checkboxes going down in a column next to the column names. This works fine, but what I would like to do is have several columns like this so that I can effectively have different default views for different users and use an option button at the top of each column to select which set of checkboxes are used.
Any help with this would be much appreciated.
Thanks!