Custom Menus in Chart Sheets
 

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

Custom Menus in Chart Sheets
 

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

"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

Custom Menus in Chart Sheets
 

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"




--
Regards Ron de Bruin
http://www.rondebruin.nl


"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

Custom Menus in Chart Sheets
 

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