0

I created an Excel Add-in in Visual Studio using C#, and it seems that the Tab Name is not showing. Disabling and enabling the add-in solves the issue, but it's not something that I can ask my customers to do... And if I close Excel I need to do the enable trick all over again. I tried changing the Tab ID, maybe it was to generic, did not work. Am I missing something? Is there something I need to do for the Tab Name to show?

As the file opened: enter image description here

After disabling and enabling: enter image description here

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
Dumitru Daniel
  • 571
  • 4
  • 19
  • Did you use the ribbon designer or ribbon XML for the custom UI? What is your ribbon XML? – Eugene Astafiev Sep 26 '22 at 21:56
  • Was this on a test installation or your dev machine? I have seen it go blank because I was doing a test addin, and my original addin went blank. I don't believe that this will affect your customers and is localized to your dev machine. – ΩmegaMan Sep 26 '22 at 22:02

1 Answers1

2

By default, if a VSTO Add-in attempts to manipulate the Microsoft Office user interface (UI) and fails, no error message is displayed. However, you can configure Microsoft Office applications to display messages for errors that relate to the UI. You can use these messages to help determine why a custom ribbon does not appear, or why a ribbon appears but no controls appear and etc. Read more about that in the How to: Show Add-in user interface errors article.

Also it makes sense to use a getLabel callback for the ribbon tab. In that case you will be able to debug the code and see what is going on under the hood. Read more about the Ribbon UI (Fluent UI) in the following series of articles:

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45