Custom Menu from Add-in VBA Not Working in Excel 2013

[el_guapo]

I created an add-in with custom VBA and forms, which also stores user preferences in worksheets in the addin. When the add-in loads, it creates a custom menu on the Add-Ins ribbon that allows the user to run the main macro, or to assign a shortcut key of their choosing. It also allows them to enter registration information.

In Excel 2013, the code is all accessible since the add-in still loads, but it doesn't add the custom menu allowing users to interact with the macros. I'm told this is due to the switch to SDI.

It seems that adding Workbook_Open code to a normal file allows the custom menu to be created, but adding the same code to an add-in file does not work.

Any suggestions would be greatly appreciated. I'm hoping a solution is not too technical since I'm a mere finance guy

Thanks in advance,

Dan

[el_guapo]

Any ideas? the behavior of Excel seems pretty buggy.

When I run the code in a normal workbook the custom menu load correctly. When I install this as an add-in, the first time I restated after loading the add-in, the custom menu loads correctly, but after the first time, it won't load. Grr

[el_guapo]

Found mention of a fix by disabling Analysis ToolPaks first, then loading your add-in. Future enabling of Analysis ToolPaks doesn't seem to be an issue at that point. Very frustrating.

http://community.spiceworks.com/topi...ng-from-ribbon