Excel Add-in: Duplicate menu item

Bulsara · May 17th, 2002, 10:13 AM

I've created an excel add-in with it's own menu item which opens automatically when you open excel.

Problem is every time you open excel it adds the same menu item. Is there any way to to make sure that it only adds one customerized menu item?

Cheers,

Hament

Anne Troy · May 17th, 2002, 11:15 AM

Your addin code needs to check for existence of the menu item and only add it if it does not exist.

Can you do that? I don't have samples where I'm at right now, but I'm sure someone does.

Nimrod · May 17th, 2002, 11:29 AM

this article from MicroSoft discusses how to: Add the Item to tool bar plus test for their existence and to delete them.
http://msdn.microsoft.com/library/de.../xlcraddns.asp

May 17th, 2002, 11:15 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Your addin code needs to check for existence of the menu item and only add it if it does not exist. Can you do that? I don't have samples where I'm at right now, but I'm sure someone does. __________________ ~Anne Troy

May 17th, 2002, 11:29 AM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	this article from MicroSoft discusses how to: Add the Item to tool bar plus test for their existence and to delete them. http://msdn.microsoft.com/library/de.../xlcraddns.asp __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 10:13 AM	#1
Bulsara New Member Join Date: May 2002 Location: london Posts: 17	I've created an excel add-in with it's own menu item which opens automatically when you open excel. Problem is every time you open excel it adds the same menu item. Is there any way to to make sure that it only adds one customerized menu item? Cheers, Hament