Exam 77-420 Microsoft Excel 2013 1. Create and Manage Worksheets and Workbooks 1.4 Customize Options and Views for Worksheets and Workbooks: Save As Macro Enabled

Save the Macro When you add Macros to a spreadsheet you need to save your work as a Macro-Enabled file. Macros are code. It is different than the default Excel file format. This page shows how to save a Macro.   1. Try it: Save the Macro Go to File->Save As.   What Do You See? The Save As window will prompt you to fill in the following:   Location: The Documents folder   File name: Sales with Macros EAN, where EAN are your initials.   Save as type: Excel Macro-Enabled Workbook   Click on Save. File ->Save As