Format columns when cells are protected

vasurfn

New Member
Joined
Jan 9, 2014
Messages
2
I need to protect a worksheet to limit the cells that users can input values into. However, I want to enable them to hide/unhide columns if the wish to see more details.

Is there a way that you can have a protected worksheet but allow users to hide/unhide columns in Excel 2007?

Thanks!
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

vasurfn

New Member
Joined
Jan 9, 2014
Messages
2
I figured it out, not sure how to remove this thread.

Click on the protect sheet button and get the list of options, click format columns and format rows.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,004
Messages
5,526,225
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top