-
Add-In for Excel (VBA)
How to build Add-In for Excel (using VBA)?
I need that each Excel loaded my Add-In will show additional menu (says MyMenu) with 2 submenus (says MyMenu1 and MyMenu2) and each submenu runs any Macro (says Macro1 and Macro2). How to write my Add-In in registry?
-
One way , since I take it that you want a .dll addin, is to use vb
and create a new Add-In project. Set it for Excel, version
whatever, add OnConnection code, OnDisConnection code, etc.
Compile into a dll....etc.
Or you could create a .xla Excel addin, protected with a password
so users can not view the module code.
HTH