Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I unlock specific cells in a spreadsheet that I protected?
I have a spradsheet that I protected and I now want to unlock some specific
cells so my users can update the cells. I tried to do this by going to Format then Cells and so on, but when I clicked on the Format tab then on the Cell option, the cell option is grayed out(not active). What is causing this and is there a work around?....Tks, MM |
#2
|
|||
|
|||
By default all cells are locked when the sheet is protected.
First, you must Unprotect the sheet via ToolsProtectionUnprotect sheet. Then.......... Select the cells you wish to unlock and FormatCellsProtection. Check "unlocked" and OK. Now ToolsProtectionProtect Sheet. This is mandatory!! Gord Dibben Excel MVP On Sun, 8 May 2005 09:00:02 -0700, "onemanhattanrebel" wrote: I have a spradsheet that I protected and I now want to unlock some specific cells so my users can update the cells. I tried to do this by going to Format then Cells and so on, but when I clicked on the Format tab then on the Cell option, the cell option is grayed out(not active). What is causing this and is there a work around?....Tks, MM |
#3
|
|||
|
|||
"onemanhattanrebel" skrev i
melding ... I have a spradsheet that I protected and I now want to unlock some specific cells so my users can update the cells. I tried to do this by going to Format then Cells and so on, but when I clicked on the Format tab then on the Cell option, the cell option is grayed out(not active). What is causing this and is there a work around?....Tks, MM That is because you protected the sheet before before you tried to unlock the cells. The workaround would be to unprotect the sheet, then unlock the cells, then protect the sheet. HTH. Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unlock specific cells in a spreadsheet that I protected? | Excel Discussion (Misc queries) | |||
how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
Run a Macro on Startup for Specific Spreadsheet | Excel Worksheet Functions | |||
Lock and Unlock cells using VBA | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |