LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Order in which add-ins run

I have an add-in that I created that inserts an item on the Worksheet
menu bar with the following code:

CommandBars(cWmb).Controls.Add(Type:=msoControlPop up,
Befo=CommandBars(cWmb).Controls.Count).Caption = cMm

where cWmb = "Worksheet Menu Bar"

The effect of this is to place my menu item just before the Help menu
item.

I would like to add my menu item just before the Window menu item. So,
theoretically, I would use:

CommandBars(cWmb).Controls.Add(Type:=msoControlPop up,
Befo=CommandBars(cWmb).Controls.Count-1).Caption = cMm

The problem I am running into is that I have a third party add-in
installed that also is programmed to have a menu item appear just prior
to the Window menu item. The way the add-ins are running, my add-in is
first, adding my menu item just before the Window menu item. The third
party add-in then runs, adding its menu item just before the Window
menu item. So instead of the order being third party menu, my menu,
window menu, the order is my menu, third party menu, window menu.

Is there any way to put some code in my add-in that would wait for the
third party add-in to run first or some other methods whereby my menu
item goes where I want it?

Thanks,
Mike.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change series plotting order without changing legend order? PatrickM Charts and Charting in Excel 6 December 2nd 09 07:43 PM
For chart syles, why doesn't color order match series order? AMiller Charts and Charting in Excel 1 October 29th 09 12:02 AM
How stop Excel file UK date order changing to US order in m.merge Roger Aldridge Excel Discussion (Misc queries) 1 October 9th 07 11:52 PM
Daily Macro to Download Data, Order and paste in order Iarla Excel Worksheet Functions 1 November 17th 04 01:59 PM
Daily Macro to Download Data, Order and paste in order Iarla Excel Programming 1 November 17th 04 11:55 AM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"