This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Course Of The Month
11 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Excel Command Bar dissappears when I select an object like a Chart
Posted on 2011-03-04
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
2
7 Comments
That is I believe for earlier office versions. Would recommend you to create Add-Ins using the Custom UI Editor For Microsoft Office.
The "Custom UI Editor For Microsoft Office" can be downloaded from
http://openxmldeveloper.org/articles/customuieditor.aspx
Sid
The "Custom UI Editor For Microsoft Office" can be downloaded from
http://openxmldeveloper.org/articles/customuieditor.aspx
Sid
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.
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
Snag It is in the Custom Toolbar menu, but on both the Worksheet and the Chart menu bar, correct? The Menu Commands menu apparently is only on the Worksheet menu bar, or it appears on both but your button is only on the Menu Commands menu on the Worksheets menu bar.
Whatever code you use to add your button has to explicitly add it to both menu bars. If it is done by menu bar index instead of name, the Worksheet menu bar is 1 and the Chart menu bar is 2.
Whatever code you use to add your button has to explicitly add it to both menu bars. If it is done by menu bar index instead of name, the Worksheet menu bar is 1 and the Chart menu bar is 2.
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
Featured Post
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 9 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.