Excel 2007 Legend Border

[clvestin]

OK-the title says it all. I can't find a way to programattically add a border to a chart legend. With the recent change to Office 2007 I also have lost my custom command bars to the Add-Ins ribbon. Is there a better way than XML to add macro icons? Enough questions for now-bet I'll be back for more.

[Bob Phillips]

With ActiveSheet.ChartObjects(1).Chart
.HasLegend = True
With .Legend
With .Border
.Color = vbBlack
.LineStyle = xlContinuous
End With
End With
End With