View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger on Excel Roger on Excel is offline
external usenet poster
 
Posts: 249
Default 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