Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - unprotect certain cells in protected sheet/workbook
Hello!
Please, help! I am trying to protect certain cells on my sheet. What I've tried to do? When protecting total sheet: Tools, protection (ok,... that seems it works). Then I would like to unprotect certain cells. I've tried to work with: Format-Cells. That does not work (as some advises here were already told here in Forum), because it does not show Protectin card in Format-Cell path. How to unprotect certain cells in this protected worksheet/book? Thank you very much for any help and advises given! Kindly, Irena |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - unprotect certain cells in protected sheet/workbook
By default, all cells are protected when sheet protection is enabled.
Hit CTRL + a(twice in 2003) to select all cells. FormatCellsProtection. Uncheck "locked" and OK out. Select the cells you want protected and FormatCellsProtection Check "locked". ToolsProtectionProtect Sheet. Note the options when protecting. Supply a password and OK. Excel's internal security is weak but this will prevent overwriting by accident. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 09:38:01 -0800, ekonomija wrote: Hello! Please, help! I am trying to protect certain cells on my sheet. What I've tried to do? When protecting total sheet: Tools, protection (ok,... that seems it works). Then I would like to unprotect certain cells. I've tried to work with: Format-Cells. That does not work (as some advises here were already told here in Forum), because it does not show Protectin card in Format-Cell path. How to unprotect certain cells in this protected worksheet/book? Thank you very much for any help and advises given! Kindly, Irena |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - unprotect certain cells in protected sheet/workbook
Dear Gord,
Thank you very much for this! I see the "problem" in my case. It should be reverse: first uncheck cells I do not want to protect, and then protect total sheet/or book :):) Now it works! Thank you once again! Kindly, Korisnik "Gord Dibben" napisao je: By default, all cells are protected when sheet protection is enabled. Hit CTRL + a(twice in 2003) to select all cells. FormatCellsProtection. Uncheck "locked" and OK out. Select the cells you want protected and FormatCellsProtection Check "locked". ToolsProtectionProtect Sheet. Note the options when protecting. Supply a password and OK. Excel's internal security is weak but this will prevent overwriting by accident. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 09:38:01 -0800, ekonomija wrote: Hello! Please, help! I am trying to protect certain cells on my sheet. What I've tried to do? When protecting total sheet: Tools, protection (ok,... that seems it works). Then I would like to unprotect certain cells. I've tried to work with: Format-Cells. That does not work (as some advises here were already told here in Forum), because it does not show Protectin card in Format-Cell path. How to unprotect certain cells in this protected worksheet/book? Thank you very much for any help and advises given! Kindly, Irena |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - unprotect certain cells in protected sheet/workbook
OK
Same thing but backwards<g Glad to hear you got sorted. Gord On Wed, 21 Nov 2007 14:29:01 -0800, ekonomija wrote: Dear Gord, Thank you very much for this! I see the "problem" in my case. It should be reverse: first uncheck cells I do not want to protect, and then protect total sheet/or book :):) Now it works! Thank you once again! Kindly, Korisnik "Gord Dibben" napisao je: By default, all cells are protected when sheet protection is enabled. Hit CTRL + a(twice in 2003) to select all cells. FormatCellsProtection. Uncheck "locked" and OK out. Select the cells you want protected and FormatCellsProtection Check "locked". ToolsProtectionProtect Sheet. Note the options when protecting. Supply a password and OK. Excel's internal security is weak but this will prevent overwriting by accident. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 09:38:01 -0800, ekonomija wrote: Hello! Please, help! I am trying to protect certain cells on my sheet. What I've tried to do? When protecting total sheet: Tools, protection (ok,... that seems it works). Then I would like to unprotect certain cells. I've tried to work with: Format-Cells. That does not work (as some advises here were already told here in Forum), because it does not show Protectin card in Format-Cell path. How to unprotect certain cells in this protected worksheet/book? Thank you very much for any help and advises given! Kindly, Irena |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forgotten Password to Unprotect Workbook/sheet | Excel Discussion (Misc queries) | |||
Unprotect a range of cells in a protected worksheet | Excel Discussion (Misc queries) | |||
unable to unprotect my protected excel file | Excel Discussion (Misc queries) | |||
Unable to unprotect a protected excel file | Excel Discussion (Misc queries) | |||
How do I unprotect certain cells in a protected sheet? | Excel Worksheet Functions |