Hi,

You will need to control where the new unprotected rows are going to be
added, because Excel passes the protection from the cells above down to the
new row. So to insert an unprotected row 3 row 2 must be unprotected.

If rows 1 and 2 are protected and you want to let the user insert a row
below those that is unprotected, then unprotect row 3 and hide it. When the
user selects row 4 (first visible row below 2) and inserts a new row that row
will be unprotected.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Colleen" wrote:

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