I have users running Excel 2007 and even Excel 2003 and this. It only needs to be removed one time: when the addin is uninstalled. However, we should really only need to add this custom menu one time: when the addin is installed. Yes, I see that this will make the Add-Ins tab visible in Excel 2013. I have no other Add-Ins enabled, I have tried running as Administrator, and my Add-Ins tab is checked to display in the ribbon. I see that the Add-In is still checked as being active, though, in the Excel Add-in window via File > Options > Add-Ins > Excel Add-ins.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)
ADD DEVELOPER TAB EXCEL CODE
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.
ADD DEVELOPER TAB EXCEL INSTALL
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.
Click anywhere to insert a default spin button, or hold and drag the cursor to define the size of the spin button. When you click the Insert button, you will see the same controls under two sections:Ĭlicking the Spin Button button changes the cursor into a plus. Once the Developer tab is visible, you can find the Option Button command under the Insert button in the Controls section.
ADD DEVELOPER TAB EXCEL HOW TO
You can see detailed steps at How to display the Excel Developer tab for using advanced features.