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 |