menubar problem - excel 2000

[cyclingsal]

Hi,
I have disabled the menubars for my application, but when a chart is
displayed using a chart window using a macro, the worksheet menu bar
becomes visible while the chart window is visible. It disappears when
the chart window is closed. Is there a way to suppress the worksheet
menu bar from showing when displaying the chart window? Thanks in
advance.

Sal

 

[Greg Wilson]

That's not actually the Worksheet Menu Bar. It's the Chart
Menu Bar. It looks exactly the same except that it has a
Chart menu in place of the Data menu. When you activate a
chart, the Worksheet Menu Bar is hidden and the Chart Menu
Bar substitutes. You need to disable this menu bar also.

Why they don't just have a hidden Chart menu item on the
Worksheet Menu Bar that is made visible when you activate
a chart and invisible when you deactivate instead of doing
it this way is beyond me.

Regards,
Greg