Hiding columns using a combobox.

[Davis10]

Is there any way to hide columns based on the values in a combo box using VBA or any other method in excel.

Also- Can you link a combobox to hide columns on another worksheet?

Thank you!

 

[Derek Brown]

Hello and welcome to The Board.
Yes, there is a way using "Custom Views". I advise creating a custom view name "Normal" first so that everything can easily be reset to 'normal'. Then it is just a case of hiding columns etc. and creating a new custom view.
You did not say which version of Excel is being used. I have used this in Excel 2003/2007/2010.
You can add the Custom Views combobox to the toolbar/ribbon.