To copy the macros to another workbook in Excel 2003 do the following:
1. Open both bmacs2003.xls workbook and the destination workbook.
2. From the Tools menu choose Macros and open the Visual Basic editor.
3. Now select Project Explorer from the View menu and you will see a list containing the names of the two workbooks that are open.
4. Select the Module1 item of the modules folder in the Barcodes.xls item and drag it to the destination item in the project list.
5. Finally from the File menu select Close and Return to Microsoft Excel.
You can now close the bmac2003 workbook. The macro are installed in the destination workbook.
More: