View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
eliano eliano is offline
external usenet poster
 
Posts: 25
Default Deleting Rows Containing Protected Cells



"Marge O." wrote:

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?
--
Baffled and confused, but determined to overcome...
Marge O.


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