Protecting Embedded Chart

K

Kevin

How do I completely lock down a chart embedded in a worksheet (not a chart
sheet) in VBA to prevent changed through the UI? I have tried:

Worksheet("MySheet").ChartObjects("MyChart").Chart.Protect
Worksheet("MySheet").ChartObjects("MyChart").ProtectChartObject = True
Worksheet("MySheet").ChartObjects("MyChart").Enabled = False
Worksheet("MySheet").ChartObjects("MyChart").Locked = True

I, of course, protected the worksheet itself also:

Sheets("MySheet").Protect Password:="SecretWord", DrawingObjects:=True,
Contents:=True, Scenarios:=True

None of these steps seem to prevent me making changes to the format of the
data series and legend. How do I lock down all of these items?

Thanks,

Kevin
 
A

Andy Smith

How about:

Worksheet("MySheet").ChartObjects("MyChart").Chart.Protect
DrawingObjects:=True, Contents:=True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with chart objects 1
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5
Excel 2003 code to use instead of ChartObjects 4
Update "centerheader" code running slowly need help speeding up 7
Selecting a chart in a worksheet with VBA trouble 2
Select statement or me? 12
Chart Variables 2
getting the active chart/chartobject's name 4

Top