Load-On-Demand Add-In Not Loaded by Permanent CommandBarButton

[Matthew Wieder]

I am writing an "automation add-in" for Excel in C#. This type of add-in
only loads on-demand, but my issue exists for a com add-in that is set to
load on demand as well. The first time the Add-In is connected, I have it
create a CommandBarButton that is permanent (the last param of the Add method
is the permanence of the CBB). Then Excel can be shut down and the
commandbarbutton still remains the next time Excel is started. However, when
I click on the button after restarting Excel, the Add-In does not load. The
documentation seems to indicate that Load on demand would Load the Add-In the
first time it is needed - either by activating a fomula from that Add-In, or
pressing a button that uses the add-in.

 

[XL-Dennis]

Hi Matthew,

Instead of setting the initially load behavior to "Load on demand" You can
test with "Load at next startup only".

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/

 

[Matthew Wieder]

Actually, I can't - as I mentioned - I have an "automation add-in" the load
behavior as defined by Microsoft is Load on Demand and cannot be changed. I
just mentioned that the behavior I described can be replicated by a regular
Com Add-In set to Load on Demand as well.