I have written a small piece of VBA code which adds a new command bar option to the main Excel menu bar. This works well and appears on the menu as expected.
Unfortunately one of the options is related to copying charts and as soon as I click on a chart in the Excel file this new menu bar gets hidden.
I'm assuming this is something to do with my new menu being added to the Standard bar and therefore not available to the Chart Menu bar but I can't figure how to get my menu bar to show on the Chart menu.
Unfortunately one of the options is related to copying charts and as soon as I click on a chart in the Excel file this new menu bar gets hidden.
I'm assuming this is something to do with my new menu being added to the Standard bar and therefore not available to the Chart Menu bar but I can't figure how to get my menu bar to show on the Chart menu.