Brian,
You can do it the following way (with Excel ---> change to appropiate host
application):
Step 1
- Start VB 6.0 and open Your project
- Open the Design form and choose the General tab
- Set the Initial Load Behavior to: None
Step 2
- Switch to the Advanced Tab in the Design Form
- Write the following in the field for Registry Key for Additional Add-in data
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\Test.Connect
- Click on the New Value Button
- In the dialog New Registry Key Data:
Datatype: String
Value Name: FriendlyName
Value Data: Test
Click OK to close the dialog
- Click on the New Value Button
- In the dialog New Registry Key Data:
Datatype: DWord
Value Name: LoadBehavior
Value Data: 3
Important: the value data is surrounded with quotes, "3" and in order to
delete them:
Select LoadBehavior in the list (Addin specific Data) and click on the Edit
Value button. Click on the OK-button (and the qotes should now have been
deleted).
The COM Add-in will be registrated only in the HKLM and in return it will be
accessible by all users BUT it will not be available via the COM Dialog in
the host application.
---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel:
http://xldennis.wordpress.com/
My English site:
http://www.excelkb.com/default.aspx
My Swedish site:
http://www.xldennis.com/
