Order in which add-ins run

[Michael Malinsky]

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:=msoControlPopup,
Before:=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:=msoControlPopup,
Before:=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.

 

[Norman Jones]

Hi Michael,

Perhaps uncheck your Addin and load it like a normal workbbook.

 

[Bob Phillips]

I am sure there are ways to do it, but none easy that spring to mind.

Is it really so important that you wan t to go to this bother?

 

[Michael Malinsky]

I really don't need to go to this bother, but since I was considering
sharing it with others I wanted to try to make it "pretty." If anyone
has any direction, it would be greatly appreciated.

Thanks,
Mike.

 

[Norman Jones]

Hi Michael,

Alternatively, uncheck your addin (Tools | Add-Ins ) and close Excel.
Re-open Excel and re-check the addin.

This will rewrite the addin's registry OPEN key and send your addin to the
end of the load queue.

The addin's OPEN key may be verified at:

Start | Run | RegEdit | HKEY_CURRENT_USER\Software
\Microsoft\Office\10.0\Excel\Options


(10.0 represents xl2002)

 

[Michael Malinsky]

I'll give it a shot.

Thanks