I open up Excel 2013 again and the Add-Ins tab is not displayed.I see that the Add-Ins tab is displayed on the ribbon and I see my own "Custom Menu." Great!.I click File > Options > Add-Ins > Excel Add-ins and browse to my AddCustomMenu.xla.
I open Excel 2013 and click to create a new workbook.Set menuholder = .Add(msoControlPopup,, , .Count, False) I open the VBA Editor and put the following code into "ThisWorkbook:" Private Sub Workbook_AddinInstall()
In Excel 2013, I create an Excel 97-2003 Add-in file named AddCustomMenu.xla. I have re-created my issue with the smallest amount of code possible. I do not receive any errors and this behavior with this same add-in does not happen in Excel 2007 (I have not checked Excel 2010 because I really don't want to install yet another version of Excel to test this!).ĭoes anyone have any tips for me? It is very frustrating for me and my users to have to open Excel, uncheck the add-in, close Excel, open Excel, re-check the add-in just to get the Add-Ins tab to show up! I have looked through all the options and the Trust Center but do not see anything that should be causing this issue (all the disable options for add-ins in the Trust Center are unchecked) but the problem persists! I have also tried to run Excel as an administrator to enable the add-in and re-open Excel as an administrator but the Add-Ins tab is still missing.
I have searched the internet and found some information regarding an issue with the Analysis Toolpak add-in and how this one must be loaded last for some reason, but this does not apply to me because I have no other add-ins enabled at all. the add-in is working, but the ribbon tab is not there. My custom functions still workĪnd I can copy/paste them to create new ones. However, when I close Excel 2013 and re-open my workbook the Add-Ins tab does not show up but the add-in is loaded just fine. The Add-Ins tab is displayed and I can use the add-in's custom functions in my workbook. Enable the add-in via Excel > File > Options > Add-Ins > Excel Add-ins > Check the box next to my add-in.The Add-Ins tab in Excel 2013 is not showing up even when the add-in is loaded.
0 kommentar(er)
