Deleting Rows Containing Protected Cells

[Marge O.]

I've created several workbooks for a project I'm leading. I've locked some
cells containing formulas, and protected the sheet, specifying that inserting
and deleting rows should be allowed. Unfortunately, I receive an error
message telling me that I'm trying to delete a row that contains a locked
cell, and that ocked cells cannot be deleted while the worksheet is
protected. Does anyone know a way to work around this short of unlocking my
formula cells?

 

[eliano]

I've created several workbooks for a project I'm leading. I've locked some
cells containing formulas, and protected the sheet, specifying that inserting
and deleting rows should be allowed. Unfortunately, I receive an error
message telling me that I'm trying to delete a row that contains a locked
cell, and that ocked cells cannot be deleted while the worksheet is
protected. Does anyone know a way to work around this short of unlocking my
formula cells?

Hi Marge.
Try to unprotect the worksheet prior to delete the entire row, and protect
again, using i.e. the event DoubleClic.
Regards
Eliano

 

[Todd A]

Hello Eliano,

Same issue, the function is supposed to allow row insertion in a protected
sheet. I have 24 sheets that are protected for a billing spread sheet. The
spread sheet is 25 MB in size, adding additional rows in the 'event of'
drastically increases the size of this spread sheet and unlocking the sheets
is time consuming and dangerous when done by persons not fluent in Excel.
Keep in mind that if a row is added in one it must be add in all sheets. How
can this error be corrected?