Excel add-in deployment

[Andrew Wiles]

I have developed a com (automation) add-in for Excel and am now working on
the deployment project. I can install and register the add-in without any
problem but would also like to "switch the add-in on" rather than require the
user to do this manually through the user interface.

Is this possible?

 

[Andrei Smolin [Add-in Express]]

Hello Andrew,

If the add-in is a COM add-in (not an Excel Automation add-in), then its
on/off state depends on the LoadBehavior value located in the following
registry branch:
HKCU (or HKLM) \ Software \ Microsoft \ Office \ %HostApplication% \ Addins
\ %YourAddin% \

LoadBehavior = 3 is the most common one. 3 means the add-in is loaded and
connected (=checked in the COM Add-ins dialog). To display the COM
Add-ins... command in a toolbar do the following:

1. Open the host application (Outlook, Excel, Word, etc)
2. On the Tools menu, click Customize.
3. Click the Commands tab.
4. In the Categories list, click the Tools category.
5. In the Commands list, click COM Add-Ins and drag it to a toolbar of your
choice.

Regards from Belarus,

Andrei Smolin
Add-in Express Team Leader
www.add-in-express.com