Exam 77-428 Microsoft Excel 2013 EXPERT 1. Manage and Share Workbooks 1.1 Manage Multiple Workbooks: Copy Macros From Workbook To Workbook

Back to Visual Basic 2. Try This: Review the Code in Visual Basic Two spreadsheets are open: Sales 2013 with Macros.xlsm (Completed) Sales 2013 More Macros.xlsm Go to Developer ->Code->Visual Basic.   What Do You See? Visual Basic for Applications will open. There are are two Projects on the left side: One for each Macro Enabled spreadsheet that is open. The Macros are in the Modules folder. Now, Try This: Copy a Module Go to VBAProject (Sales 2013 More Macros.xlsm) Select Module2 and drag it down to the Modules folder under VBAProject (Sales 2013 with Macros.xlsm). Done and Done. That's how to copy Macros from one workbook to another. Go to File->Close and Return to Microsoft Excel. Developer ->Code->Visual Basic