How to Copy Excel macros

from a sample workbook to a new workbook or template.

Copying to another Workbook for Excel 2003

To copy the macros to another workbook in Excel 2003 do the following:

1. Open both the workbook containing the macros 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 Barcodes sample workbook. The macro are installed in the destination workbook.

The new workbook may aslo be saved as a Template using the File - Save As menu and selecting Template as the file type.

Copying to another workbook for Excel 2007/2010

1. Open Excel Options from the Office icon (Excel 2007) or the File menu (Excel 2010).

2. For Excel 2007 ensure that the checkbox labelled Show Developer tab in the Ribbon is checked. For Excel 2010 select the Customise Ribbon item and ensure that the Developer checkbox is checked.

3. Open bmacs2007.xlsm and using the Options button alongside the security warning ensure that "Allow this content" is selected. For Excel 2010 just push the button labelled “Enable content”

4. Open a new blank workbook or one in which you wish to use the barcode Macros.

 5. Select the Developer tab above the Ribbon and select the Visual Basic icon.

6. In the Project section (top left) expand the topics for both the bmacs2007 and the destination workbook.

7. Select Module 1 in the bmacs2007 section, then, holding down the control key, drag it to the main heading of the other book – typically VBAProject (Book1). A Modules section will appear in the list under the second workbook.

8. Now from the File menu choose “Close and Return to Microsoft Excel”; Save your workbook as a Macro Enabled workbook.

Barcode Macros is now present in your workbook and ready for use.

The new workbook may aslo be saved as a Template using the File - Save As menu and selecting Macro Enabled Template as the file type.