Deleting Rows Containing Protected Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marge O. - 21 May 2008 01:07 GMT

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?

Signature

Baffled and confused, but determined to overcome...
Marge O.

Reply to this Message

eliano - 21 May 2008 02:27 GMT

> 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
[quoted text clipped - 3 lines]
> 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

Reply to this Message

Todd A - 31 May 2008 01:44 GMT

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?

> > 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
[quoted text clipped - 9 lines]
> Regards
> Eliano

Reply to this Message