cell protection

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Is it possible to protect cells from being formatted.

I still require data to be entered from drop downs or
free text however need to protect from others with a
constant desire to reformat alignment, validation etc.

Any help appreciated
 
Hi Graham!

Yes, it's possible.

By default, all cells are locked but this is not applied
until you have set protection. What you would need to do
is to unlock all cells except those that you want to keep
locked and apply protection to. To do this (the quickest
way) select the entire sheet then RT click, select Format
Cells, click the Protection Tab. Untick the locked box. Ok
out. Then select the cells you want to protect. Rt click,
Format Cells, Protection Tab, and reapply the tick in the
Lock box. Now, goto the main menu select
Tools>Protection>Allow users to edit ranges. Just follow
the steps in that dialogue box and when your done select
the Protect sheet button. Another dialogue will open that
lists all the actions that you can allow those users to
perform.

Long winded, but it's not that hard to do!

Biff
 
Back
Top