Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
For chart syles, why doesn't color order match series order? | Charts and Charting in Excel | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Daily Macro to Download Data, Order and paste in order | Excel Programming |