ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Commandbar not visible in a graphic (https://www.excelbanter.com/excel-programming/334930-commandbar-not-visible-graphic.html)

leglouton

Commandbar not visible in a graphic
 
Hi,

I use my own cammandbar creates in vba code and insert in the main
Excel Bar "Worksheet Menu Bar". But when a graph object is select my bar
disapear. So I cannot use my commanbar to work with a graphic.
Thanks if you can help me !


leglouton


Nick

Commandbar not visible in a graphic
 
Hi

This is because when a Chart is selected the default command bar "Worksheet
Menu Bar" is replaced with the "Chart Menu Bar". So if you have added a
custom button to the default bar it wont be shown.

There are a couple of ways around this.
Either create your own custom command bar and but your buttons on there or
add you custom button to the Chart menu Bar as well as the default.

Hope this helps


"leglouton" wrote in message
...
Hi,

I use my own cammandbar creates in vba code and insert in the main
Excel Bar "Worksheet Menu Bar". But when a graph object is select my bar
disapear. So I cannot use my commanbar to work with a graphic.
Thanks if you can help me !


leglouton




Ron de Bruin

Commandbar not visible in a graphic
 
Hi

There are two menubars

1 = the normal menubar (Worksheet Menu Bar)
2 =the chart menubar

So you must add the menu items to the chart bar also

The name is Chart Menu Bar

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


"leglouton" wrote in message ...
Hi,

I use my own cammandbar creates in vba code and insert in the main Excel Bar "Worksheet Menu Bar". But when a graph object is
select my bar disapear. So I cannot use my commanbar to work with a graphic.
Thanks if you can help me !


leglouton





All times are GMT +1. The time now is 12:26 AM.

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