Custom Menus in Chart Sheets

[Guest]

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

 

[Rob Bovey]

When a chart sheet is displayed, the menu bar changes from the Worksheet
Menu Bar to the Chart Menu Bar. If you only added your custom menus to the
Worksheet Menu Bar they will disappear along with it when a chart sheet is
activated. The easiest solution is to add your menus to both of these menu
bars so that they'll be visible no matter what type of sheet is currently
active.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Ron de Bruin]

Hi

When you activate a chart sheet you see a different menu bar

You can add the controls to both the bars if you want

"Worksheet Menu Bar"

"Chart Menu Bar"