Allow Edit Objects in protected sheets
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
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
|