All cells are locked by default, but locking does not mean anything until
you protect the worksheet from ToolsProtection 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)

--
Jacob (MVP - Excel)


"Selen" wrote:


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,