Macro to delete row with protected cells

[Turboj]

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]

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

[GS]

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

[Turboj]

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