protection error
 

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,

protection error
 

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,

protection error
 

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,