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