View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Add-In needs to create CommandBar

Have you tried OnStartupComplete?

--

HTH

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

"lucp " wrote in message Have you
tried ...
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 CommandBar
needs to be created. I have the code for that, but need to know what
event fires when the user selects the Add-In.

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


---
Message posted from http://www.ExcelForum.com/