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