Custom menus in chart sheets
 

How do I keep my custom menus in new chart sheets?

I inserted three new chart sheets, but my custom menus didn't appear
automatically.

Please send some example code in VBA to accomplish this.

--
Any help will be appreciated.

Regards,

CyberBuzzard

Custom menus in chart sheets
 

Not sure if I understand but maybe something like this -

Set objMenu = Application.CommandBars("Chart Menu Bar").Controls("Format")
With objMenu.Controls.Add(Type:=msoControlButton)
..Caption = "&MyMacro"
..OnAction = ThisWorkbook.Name & "!MyMacro"
End With

Regards,
Peter T

"CyberBuzzard" wrote in message
...
How do I keep my custom menus in new chart sheets?

I inserted three new chart sheets, but my custom menus didn't appear
automatically.

Please send some example code in VBA to accomplish this.

--
Any help will be appreciated.

Regards,

CyberBuzzard