Yes it's confusing. An aX dll addin can be a ComAddin or an Automation
addin, or both. I have a dll that loads on startup (ComAddin) to prepare
things (FWIW adds info for display in the function wizard) and as an
Automation addin for its UDF's.

As a ComAddin and with the IDTExtensibility2 there are various Load behavior
options which can be pre-defined (or changed later in the registry). At
least there are in VB6, I don't know about C#.

It wasn't clear to me what the OP had, indeed I asked (see my Q quoted
below)

Regards,
Peter T

"booleanlogic" wrote in message
...
Peter,
Why does this link say
http://support.microsoft.com/kb/291392

"All Automation Add-ins are loaded on demand; there is no setting that can
change the load behavior for an Automation Add-in"

..when we can set the load behavior of Automation addins to
load-on-startup.


"Peter T" wrote:

If you have 'Initial load behavior' set to 'load on demand' change it to
'StartUp'

In Excel, is the addin installed under Tools/Com Addins... as well as
Addins/Automation addins (if used for UDF's)

Regards,
Peter T

"NA_AB" wrote in message
...
Hi all,
I'm trying to build an excel addin using c# and visual studio. In my
addin,
I'm generating a button which I want to be displayed as soon as I open
my
excel. I did the COM registration also. The button is showing up but
only
after I start writing a "formula" in an excel cell like (=sum, =count)
etc. I
shifted my create button code from Onstartup Complete and Onconnection
of
Connect.cs but of no use.

thanks in advance