Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL chart sheets Custom size for PPT | Charts and Charting in Excel | |||
Please Help Me with Custom menus | Excel Worksheet Functions | |||
Custom menus | Excel Programming | |||
Custom faces for custom menus/commandbars | Excel Programming | |||
Custom Menus | Excel Programming |