Multiple Levels of Protection

**mkbarth** · 01-31-2010, 02:58 AM

Is it possible within the same Worksheet to have 3 different levels of protection for different cells:

1) Content editable and format changeable (Cell Protection = Unlocked)
2) Content not editable, but format changeable (Cell Protection = Locked)
3) Neither content nor format changeable (Cell Protection = Locked)

So far, using Tools / Protection / Protect Sheet, and checking:
- Select Locked Cells
- Select Unlocked Cells
- Format Cells

I can get different cells to behave according to 1) and 2).
But then, for cells needing behavior 3), formatting is left open for changing.

**Cheeky Charlie** · 01-31-2010, 07:08 AM

No. Your cells can either be locked or unlocked, when you protect the sheet you can elect how to handle each type - this is a maximum of two flavours.

CC