February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Saving a Workbook with Macros
Macros are created using Visual Basic for Applications (VBA) code. If you add a macro to a workbook, you need to save it with a file name extension that ends with an “m”, either Excel Macro-Enabled Workbook (.xlsm), or Excel Macro-Enabled Template (.xltm). If you try to save a workbook containing a macro with a file name extension that ends with an “x” (such as .xlsx or .xltx), Excel displays an alert message, restricting the operation. These Excel file types are designated to be VBA code-free.
Save a Workbook with Macros
Click the File tab, and then click Save As.
Click Computer, and then click Browse or a recent ...