Quick question on Add-in

[Shuvro Basu]

Hi All,

I need to create an add-in that will be executed when the user selects
the add-in from the list under Tools--->Add-ins in Excel. So far so
good. Now what I need this add-in to do is add a menu option in the
main excel menubar when it gets installed and show couple of options.
Ideally it will run a userform. So when the user closes the userform
the add-in needs to uninstalled and the menu deleted. Also if the user
selects an exit option from the new menu created by the add-in, it
should unload the userform and delete the menu. I need to have the code
to create the menu from the add-in at run time and also the code to
disable the menu when the add-in is unloaded. Also any clue to delete
the menu when the userform is terminated will be appreciated.

Thanks.

[Harald Staff]

Hi

See
http://www.j-walk.com/ss/excel/tips/tip53.htm
for code. Call this code from the Thisworkbooks' Open and Close events
(allows you also to run the addin as a regular opened file), or the
AddinInstall / AddinUninstall events if that is important (my 0.02 -it
should'nt be important :-)

HTH. Best wishes Harald

"Shuvro Basu" <[email protected]> skrev i melding
news:[email protected]...
> Hi All,
>
> I need to create an add-in that will be executed when the user selects
> the add-in from the list under Tools--->Add-ins in Excel. So far so
> good. Now what I need this add-in to do is add a menu option in the
> main excel menubar when it gets installed and show couple of options.
> Ideally it will run a userform. So when the user closes the userform
> the add-in needs to uninstalled and the menu deleted. Also if the user
> selects an exit option from the new menu created by the add-in, it
> should unload the userform and delete the menu. I need to have the code
> to create the menu from the add-in at run time and also the code to
> disable the menu when the add-in is unloaded. Also any clue to delete
> the menu when the userform is terminated will be appreciated.
>
> Thanks.
>