if you look at an individual cell's properties, there is a locked
checkbox on the last page. that is set by default, locking the cell
when the sheet is protected. clearing that would allow the cell to be
edited on a protected sheet.

hope that gave you the insight you need.

Sri Ram wrote:
I have a concept in my project i which I have make some rows of a worksheet
non-editable .i.e., read-only. I have tried many options but everything gave
me error. I can protect a complete worksheet but not individual rows. I would
like to know whether it is possible to protect certain rows of a worksheet &
if so, what is the function to use?