Edit/Clear/All command overrides worksheet protection

N

Nancy

I have a worksheet that is accessed by users on a network.
The necessary data entry cells are unlocked and the
worksheet is protected. When a user selects the
Edit/Clear/All command for an unlocked cell or range of
cells, the format as well as the data is removed.
Shouldn't worksheet protection protect the format of these
unlocked cells? Help!
 
P

Peo Sjoblom

No? Why would it? First of all teach your users not to use clear,
tell them to use delete.. Also note that if they clear all formats they will
lock the cell
again and thus protect it.. You can of course remove the [clear all] from
the edit menu
 
D

Dave Peterson

When you clear a range, it goes back to the defaults under the Normal Style.

You could change the normal style in that workbook so that Protection isn't
touched when you clear.

Format|style|Normal (in Style Name)
Uncheck Protection

Now when you/they clear the range, protection (lockedness) won't be changed.

And if the worksheet is protected, then they can't change the locked cells
anyway.
 
Top