Add-In needs to create CommandBar

[lucp]

I create a Add-In using VB6 with Initial Load Behaviour set to "None".
When the users selects the specified Add-In in Excel, a CommandBa
needs to be created. I have the code for that, but need to know wha
event fires when the user selects the Add-In.

Normally this code is placed in the OnConnection sub, but this onl
works when Initial Load Behaviour is set to eg. "Startup"

 

[Bob Phillips]

Have you tried OnStartupComplete?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[papou]

Hi
Workbook_AddinInstall

HTH
Cordially
Pascal

 

[lucp]

*
Workbook_AddinInstall
* You mean I need a xla/xls file as well to handle the installation of

the Add-In?

 

[lucp]

*Have you tried OnStartupComplete?
*

I did, and this is not fired when the user ticks the Add-In in Excel

 

[papou]

No but as I have just noticed you are using VB6, so this probably is not
applicable in your case.
The Workbook_AddinInstall is an Excel Application event which fires each
time an Addin has been ticked (loaded) in the Tools AddIns option from
Excel.
HTH
Cordially
Pascal

 

[Bob Phillips]

The OnCoplnnection event fires when the addin loads, regardelss of whether
it is manually loaded, or loaded at startup, OnStartupComplete only fires if
loaded at startup, so it must be the OnCoinnection event that you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[lucp]

OnConnection fires when the user ticks the addin in the COM Addin
dialog.

When I put a msgbox in the AddinInstance_OnConnection trigger, it isn'
displayed when the user ticks the addin in Excel. In VB6, the Initia
Load Behaviour is set to Load on demand.

When the Initial Load Behaviour is set to Startup, the message i
displayed. But this is not what I want