Excel Cell Protection not Working

  • Thread starter Thread starter Perimore
  • Start date Start date
P

Perimore

Hi All,

I am experiencing a problem with Excel cell locking / sheet
protection. When I format a range of cells to be locked and then
protect the sheet. Only the very first cell selected out of the wider
selection becomes read-only. If I unlock this cell then select all the
other cells then protect, none of them become read-only. Therefore the
protected cell is not moving but instead becomes just one cell on the
sheet every time if it is locked.

Any ideas?

Regards,
Sean
 
Usual procedure is..................

CTRL + a to select all cells.

Format>Cells>Protection..........uncheck "Locked"

Now select your range to lock........say A1:G10

Format>Cells>Protection.........checkmark "locked".

Now protect the sheet.


Gord Dibben MS Excel MVP
 
I tend to do this in reverse - lock everything then choose to unlock
some specific cells / ranges, especially if I am building a 'form' type
of sheet with a few user-entered parameters and then a whole bunch of
calculations (eg a dashboard where the user can enter a date range,
territory, salesperson etc, the see reports based on those criteria).

I guess it depends on the proportion to be locked / unlocked.

The behaviour Sean describes is definitely very odd, I can't reproduce
it here.

Adam
 
Usual procedure is..................

CTRL + a to select all cells.

Format>Cells>Protection..........uncheck "Locked"

Now select your range to lock........say A1:G10

Format>Cells>Protection.........checkmark "locked".

Now protect the sheet.

Gord Dibben  MS Excel MVP
Click to expand...

This is exactly what I did but only 1 cell seems to lock properly.
Might try recreating the workbook again! :-(

Thanks,
Sean
 
Back
Top