Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Commandbar | Excel Programming | |||
Tag in CommandBar | Excel Programming | |||
cant dim as commandbar | Excel Programming | |||
Find/Replace built-in dialog in XP | Excel Programming | |||
Commandbar - how to find out which msoCommandButton was pressed | Excel Programming |