best training excel vba - Excel macros

Hi Vanessa, Thanks for the post, if you have created macros in one workbook and you wish to have them available in another, other than creating your macros intially with the option Personal Macro Workbook chosen from the "Store Macro in" text box, which makes them available every time you open any workbook, you can copy them from one workbook to another by following these steps:

1. Open the workbook that contains the module you want to copy and the workbook you want to copy the module to.
2. On the Tools menu, point to Macro, and then click Visual Basic Editor.
3. On the View menu, click Project Explorer.
4 Drag the module you want to copy to the destination workbook.