Macros

Hi Ethel

To copy a macro from another workbook you need both workbooks open. We will call them "MINE" and "OTHER"

1. Go to the Visual Basic Editor

2. In the Projects window you will see both workbooks and their objects including the modules.

3. Open the Module in the OTHER workbook where the code is written. Highlight the relevant code and copy.

4. Double click the target module in the MINE workbook. Click where you want the code to go and paste.

5. Close the OTHER workbook.

Hope this helps

Carlos