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

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.