John,

I guess that you are using XL 2003, 2007 with a protection setting which
allows row insertion.

If all the cells in the row above the insertion row are locked, the default
setting, then all the cells
in the new row are locked too. If some of the cells are unlocked, then the
cells directly below in
the insertion row will be editable. However, you would be able to change
the data in all the previous
rows where the cells have this setting; which may defeat the point of
protecting in the first place.

You could do it with a vba macro, but the result would be a messy mix of
editable rows and protected
ones. The on-insertion macro could lock all existing worksheet cells before
the insertion is done. But what
if you want to go back and edit a previously inserted row?....

A simpler macro solution would be to allow certain users to unprotect the
sheet on opening the workbook and
protection being automatically applied on closure. That, though, isn't
fool-proof.

Regards
Paul





"Colleen" wrote in message
...
Hello
I am hoping that someone can help me out with this. We have a spreadsheet
that we want others to add additional rows to, our top level and below
level
row has cells that have protection on them. When we try to add additional
blank rows the protection is inherited which we don't want. Can anyone
help?
Thanks
--
Colleen John