Add-in with IDTExtensibility2 and worksheet formulae

[Lars]

Hello,

I have developed an add-in for Excel which exposes the
IDTExtensibility2 interface in order to obtain a reference to Excel
(needed to add menu entries for initialization). Once initialized, the
add-in provides functions to be used as formulae in a worksheet.

My problem is: the OnConnection method in IDTExtensibility2 does not
get called until I edit a formula provided by the add-in.

I have registered the add-in as an automation add-in. If I register it
as a COM add-in (in the registry), functions are not available for use
as worksheet formulae.

Any ideas ?

Lars

 

[Chip Pearson]

What is the load behavior setting? It sounds like it was configured for Load
On Demand.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Lars]

What is the load behavior setting? It sounds like it was configured for Load
On Demand.

The registry setting for the COM add-in is set to disabled (0). I
assume it is loaded on demand because I register it as an automation
add-in.

If I set LoadBehavior to 3 (startup) in the registry I get the menu
entry at startup and a second instance of the add-in is created when I
start to edit a formula provided by the add-in.

If I do not register the add-in in the list of automation add-ins I
cannot access the formula

Lars