By default, all cells in a worksheet are locked if the sheet is protected.

If you want certain cells to be editable, select these cells and unclock
them (Format Cells Protection tab and uncheck Locked)

Tools Protection Protect Sheet will then protect the rest of the sheet
from change.

--
Ian
--
"Sanjiv" wrote in message
...
How can I protect range of cells in a worksheet - Thanks