Excel 2007
When you point to Home tab > Cells > Format > Protect Sheet, you get all sorts of choices. But I'd like to be able to protect locked cells from formatting but allow unlocked cells to be formatted. That doesn't seem to be possible.
In other words, do anything you want to the content or formatting of unlocked cells, do nothing to locked cells.
Thanks.
By default, all the cells on a sheet are "locked" when sheet is protected.
First you select all cells and "unlock" them.
Now select those you want "locked".
Apply your rules to those cells.
Protect the sheet.
Gord Dibben MS Excel MVP
Excel 2007
When you point to Home tab > Cells > Format > Protect Sheet, you get all sorts of choices. But I'd like to be able to protect locked cells from formatting but allow unlocked cells to be formatted. That doesn't seem to be possible.
In other words, do anything you want to the content or formatting of unlocked cells, do nothing to locked cells.
Thanks.
This isn't what I meant.
(Also, how do you apply the protection rules (in Home tab > Cells > Format > Protect Sheet) to cells? Once you protect the sheet, the sheet is protected, with locked and unlocked cells behaving differently depending on the specific checkboxes you selected in the Protect dialog.)
I would like, when the sheet is protected, for users to be unable to change the text and the formatting of locked cells, and to be able to change the text and formatting or unlocked cells. The Protect dialog does not appear to give this option.
>
First you select all cells and "unlock" them.
Now select those you want "locked".
Apply your rules to those cells.
Protect the sheet.
Gord Dibben MS Excel MVP
>
When you point to Home tab > Cells > Format > Protect Sheet, you get all sorts of choices. But I'd like to be able to protect locked cells from formatting but allow unlocked cells to be formatted. That doesn't seem to be possible.
In other words, do anything you want to the content or formatting of unlocked cells, do nothing to locked cells.
Thanks.- Hide quoted text -
- Show quoted text -
I think you missed a point or two about locking and protecting.
I assume you do not know how to select cells and format them as locked or unlocked.
Start here............................
Select all cells(CTRL + a) on the sheet
On Ribbon go to Home>Format>Format Cells>Protection.
Uncheck the "locked" option and OK your way out.
Now select only those cells you wish to be locked.
Format them to "locked"
Now change to Review Tab on Ribbon go to "Protect sheet"
You will see the list of what users are allowed to do to the locked cells.
Choose some or none then OK
Your sheet is now protected and only unlocked cells can be formatted or edited.
Gord
This isn't what I meant.
(Also, how do you apply the protection rules (in Home tab > Cells > Format > Protect Sheet) to cells? Once you protect the sheet, the sheet is protected, with locked and unlocked cells behaving differently depending on the specific checkboxes you selected in the Protect dialog.)
I would like, when the sheet is protected, for users to be unable to change the text and the formatting of locked cells, and to be able to change the text and formatting or unlocked cells. The Protect dialog does not appear to give this option.
>
First you select all cells and "unlock" them.
Now select those you want "locked".
Apply your rules to those cells.
Protect the sheet.
Gord Dibben MS Excel MVP
>
When you point to Home tab > Cells > Format > Protect Sheet, you get all sorts of choices. But I'd like to be able to protect locked cells from formatting but allow unlocked cells to be formatted. That doesn't seem to be possible.
In other words, do anything you want to the content or formatting of unlocked cells, do nothing to locked cells.
Thanks.- Hide quoted text -
- Show quoted text -
I missed a point or two in my reply to your reply
After you hit Review>Protect Sheet, uncheck "select locked cells".
Checkmark "Format Cells" and any others you want and OK
Now you can format any cell that you can select(which would not be locked cells)
Gord
I think you missed a point or two about locking and protecting.
I assume you do not know how to select cells and format them as locked or unlocked.
Start here............................
Select all cells(CTRL + a) on the sheet
On Ribbon go to Home>Format>Format Cells>Protection.
Uncheck the "locked" option and OK your way out.
Now select only those cells you wish to be locked.
Format them to "locked"
Now change to Review Tab on Ribbon go to "Protect sheet"
You will see the list of what users are allowed to do to the locked cells.
Choose some or none then OK
Your sheet is now protected and only unlocked cells can be formatted or edited.
Gord
This isn't what I meant.
(Also, how do you apply the protection rules (in Home tab > Cells > Format > Protect Sheet) to cells? Once you protect the sheet, the sheet is protected, with locked and unlocked cells behaving differently depending on the specific checkboxes you selected in the Protect dialog.)
I would like, when the sheet is protected, for users to be unable to change the text and the formatting of locked cells, and to be able to change the text and formatting or unlocked cells. The Protect dialog does not appear to give this option.
>
First you select all cells and "unlock" them.
Now select those you want "locked".
Apply your rules to those cells.
Protect the sheet.
Gord Dibben MS Excel MVP
>
When you point to Home tab > Cells > Format > Protect Sheet, you get all sorts of choices. But I'd like to be able to protect locked cells from formatting but allow unlocked cells to be formatted. That doesn't seem to be possible.
In other words, do anything you want to the content or formatting of unlocked cells, do nothing to locked cells.
Thanks.- Hide quoted text -
- Show quoted text -