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