| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting Rows Containing Protected Cells
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? "eliano" wrote: "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #REF appearing when cells,rows,cols are all protected | Excel Discussion (Misc queries) | |||
| MACRO HELP - deleting rows containing a range of blank cells | Excel Discussion (Misc queries) | |||
| Deleting rows with locked cells | Excel Discussion (Misc queries) | |||
| Help !!! Deleting rows in protected document ?!? | Excel Discussion (Misc queries) | |||
| Deleting rows with blank cells | Excel Worksheet Functions | |||
Linear Mode
