Allow Edit Objects in protected sheets

[Roger on Excel]

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

 

[Gord Dibben]

The macro recorder is your friend

ActiveSheet.Protect DrawingObjects:=False


Gord Dibben MS Excel MVP

 

[Roger on Excel]

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