How to installed submenu automatically after installed add-ins at add-ins manager

Posted by Nattasira Yauvasuta on December 05, 2001 8:25 AM

I had create XL-Add-ins called Utilities. After I installed add-ins by
using Add-ins manager, I would like the File menu has the new submenu
(Save All menuitem) immediately. same as lookup wizard add-ins and in
the Macro dialog has the Macro's namesList that was stored in the add-ins
too. How can I do that? Which event that i must use? And what is the
code for add submenu after installed excel add-ins.

Thank you for your help.

Posted by Juan Pablo G. on December 05, 2001 9:14 AM

Look at the Workbook_AddinInstall and Workbook_AddinUninstall

The first one to "put" the submenus in the File Menu and the second one to "remove" it after uninstalling.

Juan Pablo G.