protection error

  • Thread starter Thread starter Selen
  • Start date Start date
S

Selen

I have a problem with protection tool in excel. I set protection to
worksheet, but it had not applied to whole sheet. Some parts can still be
editing. Why protection does not applied to whole worksheet? How can I fix it?

Could you help me please?

Thanks,
 
The cells on the sheet that can still be edited are probably not "Locked".

Select one of those cells and use Format --> Cells and go to the
[Protection] tab. If the check box next to "Locked" is empty, it means that
the cell may be edited even when the sheet is protected.
 
All cells are locked by default, but locking does not mean anything until
you protect the worksheet from Tools>Protection menu.

--First select any cells that a user is allowed to change
--Hit Ctrl+1 and go to the 'Security' tab to unlock these cells.
--Go to Tools->Protection->Protect Sheet, and you can assign a password
(optional)
 
Back
Top