graphci1

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

File ->Open

no

Copy a Macro to Another Macro Enabled Spreadsheet

The process to copy a Macro from one spreadsheet is not as simple as "Copy and Paste." Microsoft Excel uses Visual Basic to copy a Macro from one Macro Enabled file to another. Here are the steps.

1. Before You Begin: Open Another File
This example needs two Macro Enabled spreadsheets open at the same time. Please download, open and enable the sample file:
Sales 2013 More Macros.xlsm

Keep going...

pic1