asked on Excel Command Bar dissappears when I select an object like a Chart
I have Addin menu items that work just fine, but when I'm on an Active Chart (in sheet or as separate tab) the Addin menuitems dissappear!
What gives?
Dave
What gives?
Dave
Microsoft ApplicationsMicrosoft ExcelMicrosoft Office
Last Comment
dlmille
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
The behavior described is from Excel 2003 or earier. The Custom UI designer only has an effect on Excel 2007 or later.
The menu is added to the Worksheet menu bar. When a chart is selected, the Worksheet menu bar is hidden and the Chart menu bar appears. Since the menu was not also added to the Chart menu bar, it disappears when the menu bars switch.
Unfortunately the add-in designer didn't think to add the menu to both menu bars. You may be able to copy it to the Chart menu bar, and it may still be there the next time you start Excel.
On the Tools menu, choose Customize. On the Toolbars tab, make sure both the Worksheet Menu Bar and Chart Menu Bar are checked. This makes both menu bars visible. Hold Ctrl while you click and drag the menu from the Worksheet menu bar to the Chart menu bar (holding Ctrl makes a copy of the menu).
If the add-in designer forgot to add the menu to the Chart menu bar, he probably also didn't plan to remove it, so it is likely to persist between Excel sessions.
The menu is added to the Worksheet menu bar. When a chart is selected, the Worksheet menu bar is hidden and the Chart menu bar appears. Since the menu was not also added to the Chart menu bar, it disappears when the menu bars switch.
Unfortunately the add-in designer didn't think to add the menu to both menu bars. You may be able to copy it to the Chart menu bar, and it may still be there the next time you start Excel.
On the Tools menu, choose Customize. On the Toolbars tab, make sure both the Worksheet Menu Bar and Chart Menu Bar are checked. This makes both menu bars visible. Hold Ctrl while you click and drag the menu from the Worksheet menu bar to the Chart menu bar (holding Ctrl makes a copy of the menu).
If the add-in designer forgot to add the menu to the Chart menu bar, he probably also didn't plan to remove it, so it is likely to persist between Excel sessions.
ASKER
So. I am the addin designer, lol and my menus work great, even between Excel sessions, than you for that advice anyway. When I select the chart, then flip to Addins - some professional addins are there, but not mine. I should not have to add it to the Chart menu bar to use the menu function.
Snag it is in the Custom Toolbar menu, where mine is under the group called Menu Commands. Is there a difference?
Dave
Snag it is in the Custom Toolbar menu, where mine is under the group called Menu Commands. Is there a difference?
Dave
Your help has saved me hundreds of hours of internet surfing.
fblack61
SOLUTION
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Snag It is only on the custom toolbar menu. I found that if I made my menubar FLOATING, it also shows up on the custom toolbar menu.
This is the solution, I think. Thanks for help on both avenues - I'll be looking into custom UI and Jon also gave some ideas so I'll be splitting.
Dave
This is the solution, I think. Thanks for help on both avenues - I'll be looking into custom UI and Jon also gave some ideas so I'll be splitting.
Dave
ASKER
My solution - to use floating menubar, actually allowed my menu items to get on the custom toolbar menu - and hence be available when chart was selected.
http://www.office-outlook.com/outlook-forum/index.php/m/113765/
Sid