You can create compiled COM or managed code add-ins as DLLs using Visual Studio.

--

(ChuckM) wrote in message om...
I've got a bunch of macros in my workbook (500kb). This workbook
will be used as a template for others to use, enter data and run the
macros. Is there a way to compile the VB so that it won't take up so
much space?
thanks
chuck