View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Editing a Chart on a protected worksheet

With the sheet unprotected...
Select the chart as a chartobject (hold ctrl and select)
Right click, Protection, untick Locked
Protect the sheet

Regards,
Peter T

"OMER" wrote in message
...
Hola,
I wonder if there is a way to allow the user to edit an embedded chart
within a protected worksheet. I know that setting the parameter
DrawingObjects=True (when protecting the worksheet) allows for editing
while
protected. However, in the worksheet there are other shapes that I don't
want
the user to be able to edit.
Is there a way accomplish this using VBA code?
Thank you in advance for your reponse.
OMER