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

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


--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.


"Ken Jones" wrote:

> 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,

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

"Dale Fye" wrote:

> 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
>
>
> --
> Don''t forget to rate the post if it was helpful!
>
> Email address is not valid.
> Please reply to newsgroup only.
>
>
> "Ken Jones" wrote:
>
> > 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

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".

--
Regards,
Bill Renaud

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/downlo...ls-scanner.php

Regards from Belarus,

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


"Bill Renaud" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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".
>
> --
> Regards,
> Bill Renaud
>
>
>