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