Excel Cell Protection not Working

[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

 

[Gord Dibben]

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

 

[AdamV]

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

 

[Perimore]

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

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

Thanks,
Sean