I have a massive (150 column) sheet that it broken down into the items and 5 sections, with a combo box indirectly driving a macro to hide 4/5ths of it at a time.

I need to protect the sheet, but this prevents any columns being hidden or unhidden both manually and by the combo box. How do I get round this?

Thanks
Hugh