ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   menubar problem - excel 2000 (https://www.excelbanter.com/excel-programming/298891-menubar-problem-excel-2000-a.html)

cyclingsal

menubar problem - excel 2000
 
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[_4_]

menubar problem - excel 2000
 
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

-----Original Message-----
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
.



All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com