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.

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

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,