Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
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" -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
Hi
Workbook_AddinInstall HTH Cordially Pascal "lucp " a écrit dans le message de ... 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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
papou wrote:
* Workbook_AddinInstall * You mean I need a xla/xls file as well to handle the installation of the Add-In? --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
Bob Phillips wrote:
*Have you tried OnStartupComplete? * I did, and this is not fired when the user ticks the Add-In in Excel -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
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 "lucp " a écrit dans le message de ... papou wrote: * Workbook_AddinInstall * You mean I need a xla/xls file as well to handle the installation of the Add-In? --- Message posted from http://www.ExcelForum.com/ |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
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 " wrote in message ... Bob Phillips wrote: *Have you tried OnStartupComplete? * I did, and this is not fired when the user ticks the Add-In in Excel. --- Message posted from http://www.ExcelForum.com/ |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
Hi Lucp,
Normally this code is placed in the OnConnection sub, but this only works when Initial Load Behaviour is set to eg. "Startup". OnConnection fires when the user ticks the addin in the COM Addins dialog. In the OnConnection event, you check to see if your menu already exists and add it if not (permanently and with the OnAction set to <!MyProject.MyConnect, so your addin also loads when it's clicked). Either way, you then set up your event hook (withevents variable) to use it. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In needs to create CommandBar
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 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create CommandBar in xl95 code - possible? | Excel Programming | |||
Cannot create transparent XP CommandBar picture | Excel Programming | |||
commandbar | Excel Programming | |||
Moving CommandBar using VBA or C# | Excel Programming | |||
Create new commandbar with call procedure | Excel Programming |