Custom UI Runtime Error in Visual Studio Tools for Office Design-Time Adaptor for Excel
This error drove me crazy because I could only find pieces of the answer, but never the whole answer. Here’s the whole answer that resolved the problem for me.
The Error: The Call to GetCustomUI() for RibbonID “Microsoft.Excel.Workbook” failed.
It typically comes up after an installation of Microsoft Office and Visual Studio. Somehow the combination of these two causes the problem and Microsoft hasn’t figured out why, or how. There is a workaround.
Step 1: Open Excel in Administrator mode
There are two ways to do this.
A) Right click on the Excel shortcut and click on Properties in the context menu. In the properties dialogue click the Advanced button. In the Advanced Properties dialogue check off “Run as Administrator” and click OK on all the open dialogues.
B) Click the Start Button, or the Windows button. Type Excel in the search box. Press SHIFT + CTRL + Enter
Open a blank workbook
In the workbook file menu select “Options” and in the Options menu select “Customize Ribbon”.
In the right hand list of the Ribbon Customizer you should see a list of tabs. Make sure the “Developer” tab is selected.
Click OK to close the Customizer
Step 3: Turn off the “Visual Studio Tools for Office Design-Time Adaptor for Excel”
In the Developer tab select the “COM Add-Ins”
In the COM Add-Ins dialogue look for the “Visual Studio Tools of Office Design-Time Adaptor for Excel” add in. You’ll likely see one for every version of Visual Studio that you’ve installed on this particular machine. Uncheck all of them and click OK out of the dialogue
That should immediately resolve the problem.
Once you open Excel in non-Administrator mode you might encounter the problem again. If that’s the case follow the above steps without opening Excel as an Administrator.