Built-in Commandbar, can't find the right one

[Ken Jones]

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

 

[Dale Fye]

Ken,

My guess is that you have found what you are looking for but that the other
two buttons are only visible under certain circumstances.

Try adding your button to that menubar and then see whether it shows up when
you right click on the legend or under whatever other circumstance you expect
that commandbar to show itself.

Dale

 

[Ken Jones]

Dale,

I've actually tried that. If I run the same code on the "Object/Plot" or
"Plot Area" or "Series" Commandbars, it's great! The button appears and I
can code a handler method for it. But it doesn't work for say the "Format
Axis", "Format Legend Entry", or "Trendline" menus. That's why it seems that
I'm not getting hold of the correct menu item. Earlier I made a stab at
running through all the Commandbars and adding the button to ALL of them, and
even then, I don't think it appeared on the three commandbars I mention
above. I wonder if there's something fundamentally different about those
popup menus, that they aren't really a "CommandBar" object?

Ken

 

[Bill Renaud]

Playing around with my CommandBarTests workbook (which lists CommandBars,
their positions, Type, etc.), I think you may be looking for a popup
commandbar (msoBarTypePopup) named "Chart".

 

[Andrei Smolin [Add-in Express]]

You can use our free Built-in Controls Scanner to find more details about
built-in command bars and their controls.

Download it at http://www.add-in-express.com/downloads/controls-scanner.php

Regards from Belarus,

Andrei Smolin
Add-in Express Team Leader
www.add-in-express.com