Hide and Protect Columns -Excel 2007

Hi,
I need help on how to hide and protect columns in excel 2007
Thank you very much

Did you try: 1) right click the column to be hidden and choose "hide" and 2) click "Protect Sheet" in Changes under Review on the ribbon (password to unprotect is optional)?

Thank you so much for your advise. I was looking for an option to unhide while the columns were protected, but looks like I have to unprotect the columns first and then unhide each time I want to see the content of the columns.

You could record a macro to unprotect>show, and another one for hide>protect, although I try to avoid VBA in Excel (and I am an expert with VB6, just causes too much confusion to average users when VBA gets involved.)

Originally Posted by cnodnarb

You could record a macro to unprotect>show, and another one for hide>protect, although I try to avoid VBA in Excel (and I am an expert with VB6, just causes too much confusion to average users when VBA gets involved.)

Hi, i am a novice with macro and VBA never used this options but i am keen to learn. Thank you for your reply!