If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, |
#3
|
|||
|
|||
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, |
Thread Tools | |
Display Modes | |
|
|