Is the code in a *.VBA file (VBA extension)?

1. Start up Excel.
2. Create a new workbook.
3. Go into the VBA editor.
4. Import the VBA code from the file.
5. Compile the code and exit the VBA editor.
6. Back in Excel, use File|Properties to enter a Title and Comment (these
will show up in the add-ins dialog box during installation of the add-in).
7. Save the workbook as a Microsoft Excel Add-In (listed at the bottom of
the "Save as type" drop-down field).

--
Regards,
Bill Renaud