View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Jones Ken Jones is offline
external usenet poster
 
Posts: 2
Default Built-in Commandbar, can't find the right one

In Excel 2003 I'm trying to add a custom button to several chart related
commandbars. The code I'm using is littered all over the Internet and works
well. For example...

Dim menuCtl As CommandBarButton
Set menuCtl = CommandBars(strName).Controls.Add(msoControlButton , , , , True)
With menuCtl
.Caption = "Do It Mister!"
.OnAction = "DoClickThing"
End With

As long as I provide the correct "strName" string value to grab the correct
commandbar, it works great. The problem is that I can't seem to find the
correct commandbar for chart legends or chart titles. I would think that the
legend, the proper commandbar would be "Format Legend Entry", but I've
noticed that when I iterate on the controls for that commandbar, it lists two
buttons that aren't on the menu displayed, which are "Hide Detail" and "Show
Detail". To be more clear, when I right click on the chart legend, here are
the optionds displayed in the menu that comes up:

Format Legend...
Clear

But if I cycle through the controls on the "Format Legend Entry" I get the
following button captions:

Format Object
Hide Detial
Show Detail
Clear

So once the question is, what's the proper name of the menu I'm looking for?

Thanks,

Ken