Excel 2013 breaks add-in installation that worked in 2007 - now only in current workbook

The following installation code worked in Excel 2007 for permanently installing a macro in the Add-ins.
With Excel 2013 the Add-in is only present in the workbook that was active during the installation.

Please Login or Register  to view this content.

Is there a fix to make this code work as intended in Excel 2013?

What is the Excel 2013 preferred way to do this programmatically?

Is there a simple way for an end user to install the macro globally and permanently into Excel 2013?

If it matters, the macro is hidden (so that the code is not visible to the end user)?


I spent some time looking through this forum for answers.
I could not find any partly because my searches were returning hundreds of posts which only matched some of my search words.


Thanks in advance,

Michael

Rory,

Thanks for the reply.

This installs the add-in option ONLY in the ribbon for the workbook that was active at the time of running the installation procedure.

Other workbooks which are created by another application (exported by QuickBooks Point of Sale) do not show the add-in option in the ribbon when they are opened.

It's as if an option were set to specify the add-in only apply to the current spread sheet. Since they changed the ribbon architecture to more personalize the ribbon, it seems like this could be happening.


Is it possible that something in the 3rd party exported spread sheet is prohibiting the add-in from being present. Seems unlikely, unfortunately I don't have the 2013 environment to test at the moment.

Bye the way, that install code works in 2010 the same as in 2007.


Thanks in advance for any help or ideal,

Michael

The other workbooks being opened manually.

The current code is used because it is legacy, from Excel 2003, and simple.

The new ribbon interface seems overly complicated for the simple task we need (add a macro that can be used to process the Quickbooks exports).
Perhaps my recent brief look at it missed a simple way to use it.

romperstomper,

Did you get a chance to look at this?

I got a chance to test on a 2013 system again. The results are squirrelly. Sometimes the macro is in the add-ins when loading a new workbook. Sometimes not. Sometimes the "pdf " operation normally found only in the "pdf" tab shows up in the add-ins tab, with or without my macro also being listed there. That is, something in excel is hosed.

When my macro does not show up in the add-ins it still shows up in the file->options->add-ins.

Thanks in advance for anyone trying to corroborate this.