macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2003

Colin has attended:
Excel Advanced course

Macros

How can you copy macros between workbooks?

Copying 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


 

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips


Server loaded in 0.09 secs.