Creating An Add-in From An Excel Macro.
Introduction
Excel is one of the most frequently used applications in business.
The program is packed with standard functions and options, but also
offers Visual Basic for Applications to automate repetitive tasks or
even write your own functions. Many users start by recording their
actions into a macro. They soon discover that the macro recorder
delivers code that needs tweaking and thus start programming VBA.
Sometimes a user has developed a macro that is so useful that it would
be interesting to hand it over to others as well.
At that point, the macro will have to be made ready for distribution.
This article gives an overview of the things that need to be taken into
account to do this.