View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew[_16_] Andrew[_16_] is offline
external usenet poster
 
Posts: 66
Default Add control to the Chart menu of "Chart Menu Bar" commandbar

Can anyone help me to get the following to work? It works fine when
adding a button to the menus on the "Worksheet Menu Bar" (eg. replace
"Chart" with "File") but I can't seem to get it to work for the Chart
menu.

Sub AddCltToChartMenu()
Dim cbct As CommandBarControl
Set cbct = Application.CommandBars("chart").Controls.Add(msoC ontrolButton)
cbct.Caption = "Test"
End Sub

Thanks,
Andrew