I use code to lock multiple sheets.

I need to be able to allow the pasting/editing of objects in my protected
sheets.

Does anyone have the code to do this.

For example I use

AllowFormattingCells:=True
and
AllowFormattingRows:=True

to enable other options in protected sheets.

I find that AllowEditObjects:=True doesnt work.

Can anyone help?

Thanks,

Roger

The macro recorder is your friend

ActiveSheet.Protect DrawingObjects:=False


Gord Dibben MS Excel MVP

On Mon, 4 Aug 2008 17:40:00 -0700, Roger on Excel
<(E-Mail Removed)> wrote:

>I use code to lock multiple sheets.
>
>I need to be able to allow the pasting/editing of objects in my protected
>sheets.
>
>Does anyone have the code to do this.
>
>For example I use
>
>AllowFormattingCells:=True
>and
>AllowFormattingRows:=True
>
>to enable other options in protected sheets.
>
>I find that AllowEditObjects:=True doesnt work.
>
>Can anyone help?
>
>Thanks,
>
>Roger

Thanks again Gord,

By the way i tried to make pivot table active by using the recorder to
generate code for me, but it doesnt seem to work.

Do you have any advice on getting pivot tables to work on protected sheets
using code?

Best regards,

Roger



"Gord Dibben" wrote:

> The macro recorder is your friend
>
> ActiveSheet.Protect DrawingObjects:=False
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 4 Aug 2008 17:40:00 -0700, Roger on Excel
> <(E-Mail Removed)> wrote:
>
> >I use code to lock multiple sheets.
> >
> >I need to be able to allow the pasting/editing of objects in my protected
> >sheets.
> >
> >Does anyone have the code to do this.
> >
> >For example I use
> >
> >AllowFormattingCells:=True
> >and
> >AllowFormattingRows:=True
> >
> >to enable other options in protected sheets.
> >
> >I find that AllowEditObjects:=True doesnt work.
> >
> >Can anyone help?
> >
> >Thanks,
> >
> >Roger
>
>