Excel Add In's Custom Ribbon Tab Will Not Display
Solution 1
I also had this problem, where my VSTO ribbon wasn't being displayed.
Here's my solution, using Excel 2013 and VS2015.
What you need to do is:
- Open the Ribbon Designer window
- Select the
RibbonTab
object - In the "Properties" window, expand "
ControlId
" branch, and change theControlIdType
from "Office
" to "Custom
"
Ridiculous, hey ?
But, strangely, it works...
Solution 2
After much pain, I found that the Position
property of the RibbonGroup
must be Default
.
Michael
Updated on June 11, 2022Comments
-
Michael almost 2 years
I've created an application level add-in for Excel to automate some tasks. I used the VS2012 template Visual C# > Office > 2010 > Excel 2010 Add-In.
Rather than having an action pane open every time Excel does, I've opted to create a custom ribbon tab following these instructions:
http://msdn.microsoft.com/en-us/library/vstudio/bb386104.aspx
However, when I build my project, the tab does not display. I have verified the add-in is loading, and all of its features function properly, except the Ribbon. I created a simple form to test this, which loads as expected.
I then tried creating an Excel 2010 Workbook project. After adding the Ribbon (using the same steps as before) and building the project, it simply works; the ribbon tab appears as expected.
I've tried overriding ThisAddIn.CreateRibbonExtensibilityObject() to return my ribbon object, created via Globals.Factory.GetRibbonFactory().CreateRibbonManager. Again, no dice.
I'm at a loss now.
-
sura2k over 6 yearsMay be strange.. MSDN says the same :) msdn.microsoft.com/en-us/library/bb386104.aspx. Otherwise ribbon is visible under built-in "ADD-IN" ribbon group. Since we need our label, need this change.
-
Ehsan88 over 5 yearsSimilarly, if you use RibbonXML you should add an
id
attribute to your<tab>
and removemsoId
attribute. -
Keith Howard over 3 yearsHi Mike, We wasted a lot of time trying to find that setting. Thanks! Do you know exactly where the setting is stored? I am trying to see the text file (and text within that file) containing that setting.