The cell I wish to protect is definately locked and the sheet is protected.

"kfogle" wrote:

The first thing I would check is this. Make sure that the cells you
want to protect are formatted at "Locked". Protection only works on
Locked cells.

(Select Cell) Format Menu Cells Protection