custome formating

  • Thread starter Paul_of_Abingdon
  • Start date
P

Paul_of_Abingdon

I have an excel sheet, which is accessed by many people to enter data. The
sheet also has various cells with formula that needs protection. So, I have
used "lock cell" and "protect sheet" to protect it. Since this sheet is very
long and wide, I want user to be able to "hide" "unhide" rows and/or columns.
But when the protection option is on, hide and unhide options are not
available. What would be a better solution to achieve this option?
 
J

Jim Rech

If you select "Format columns" and "Format rows" from the Protect Sheet
dialog you should get what you want. Excel 2002 and later.

--
Jim
message |I have an excel sheet, which is accessed by many people to enter data. The
| sheet also has various cells with formula that needs protection. So, I
have
| used "lock cell" and "protect sheet" to protect it. Since this sheet is
very
| long and wide, I want user to be able to "hide" "unhide" rows and/or
columns.
| But when the protection option is on, hide and unhide options are not
| available. What would be a better solution to achieve this option?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top