| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to delete row with protected cells
I have some formula set up in several columns so I lock the columns and
protect the sheet to avoid formula being deleted unintentionally. I want to somebody else who use the sheet can delete row without unprotecting the sheet. Can Macro help in this case and how? I am a newbie on VBA and your help is apprieciated! Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to delete row with protected cells
You could provide a macro that:
unprotected the worksheet deleted the row with the activecell protected the worksheet Turboj wrote: I have some formula set up in several columns so I lock the columns and protect the sheet to avoid formula being deleted unintentionally. I want to somebody else who use the sheet can delete row without unprotecting the sheet. Can Macro help in this case and how? I am a newbie on VBA and your help is apprieciated! Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to delete row with protected cells
See my reply 2 posts back ("Deleting a protected row")
Regards, GS "Turboj" wrote: I have some formula set up in several columns so I lock the columns and protect the sheet to avoid formula being deleted unintentionally. I want to somebody else who use the sheet can delete row without unprotecting the sheet. Can Macro help in this case and how? I am a newbie on VBA and your help is apprieciated! Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to delete row with protected cells
thanks all for your help
"GS" wrote: See my reply 2 posts back ("Deleting a protected row") Regards, GS "Turboj" wrote: I have some formula set up in several columns so I lock the columns and protect the sheet to avoid formula being deleted unintentionally. I want to somebody else who use the sheet can delete row without unprotecting the sheet. Can Macro help in this case and how? I am a newbie on VBA and your help is apprieciated! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete unprotected cells in protected worksheet | Excel Worksheet Functions | |||
| How do I delete only the content of cells that are NOT protected? | Excel Discussion (Misc queries) | |||
| Programmatically delete macro using a protected project | Excel Programming | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
| delete all but protected cells | Excel Programming | |||
Hybrid Mode
