protection error

[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,

 

[JLatham]

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.

 

[Jacob Skaria]

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)