You asked a similar question (only referring to chart menus) two days ago,
you also asked for "some example code".
I posted some example code, to place an item under the Format menu of the
"Chart Menu Bar", which incidentally is also becomes the active bar when an
embedded worksheet chart is selected.
http://tinyurl.com/afk9g
If viewing the example in GoogleGroups, remove the dash in
"msoControlButton", which Google took upon themselves to insert.
Regards,
Peter T
"CyberBuzzard" wrote in message
...
I have a workbook comprised of only regular sheets. I developed some
custom
menus for this workbook.
When I programmatically inserted three new chart sheets, none of them
displayed the custom menus I developed. My concern is that the user will
not
be able to utilize these menus from the chart sheets.
If anyone has a solution please post some example code. Maybe the only
solution is to NOT create a chart sheet but instead embed the chart in a
new
sheet. Not my prefered solution, but hey, we are only human.
--
Any help will be appreciated.
Regards,
CyberBuzzard