By default all cells are locked.

Perhaps those rogue cells were unlocked previously and remain so.

Maybe start over?

CTRL + a to select all cells.

FormatCellsProtectionLockedOK

Now select the cells you want unlocked and see what occurs when you protect the
sheet.


'Gord Dibben MS Excel MVP


On Tue, 19 Jun 2007 07:23:21 -0700, wrote:

I'm having problems locking a specific set of cells in my
spreadsheet. The issue is mainly that I will specify what cells I
want locked and what users are allowed to change, but Excel leaves
some extra cells unlocked for no reason that I can discern. What am I
doing wrong?

The specifics:
- I tell Excel that I want only the following cells unlocked for
editing: D13:G19, I13:J19, D27:G33, I27:J33, F52
- Excel does what I tell it to do but also leaves the following cells
unlocked: B22:K22, B37:K37

Is there any possible reason for this odd behaviour?