View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lars[_4_] Lars[_4_] is offline
external usenet poster
 
Posts: 2
Default Add-in with IDTExtensibility2 and worksheet formulae

On Jun 25, 1:24 pm, "Chip Pearson" wrote:
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