Macros

Hi Colin

To copy macros from one workbook to a nother you need to do the following:

1. Open both workbooks

2. In the Tools menu, select Macro and click Visual Basic Editor

3. In the Visual Basic Editor (VBE) there is a Projects area (in the left panel) displaying the 2 open workbooks as projects (lets call them A and B)

4. in the area of the workbook that is receiving the code (B)make sure that there is a Module. (If not select the Insert Menu and Click Module)

5. In the area of the workbook where the original macro is saved (A) find it in a Module

6. When you found the macro to be copied, highlight the whole macro including the Sub and End Sub lines and Copy.

7. Double click the Module in Workbook B and paste te macro in it.

The macro will now run in its new workbook as normal

Hope this helps

Carlos