See all How-To Articles

How to Save a Macro Enabled Workbook in Excel

In this tutorial, you will learn how to save a macro-enabled workbook in Excel and Google Sheets.

 

excel save macro enabled file

 

Save a Macro-Enabled Workbook (.xlsm)

In Excel you can create a macro, using the macro recorder. If you are working with standard Excel file type (.xlsx), save it as a macro-enabled workbook (.xlsm) to be able to use macros.

Note that this isn’t necessary with the old Excel type (.xls), as it’s already macro-enabled.

Create a Macro

Macros can help you to reduce repetitive work in Excel by recording a set of actions and repeating them by running the macro. To record a macro, follow these steps:

1. In the Ribbon, go to View > Macros > Record Macro.

 

record macro excel

 

2. In the Record Macro window, (1) enter a macro name and a (2) shortcut key, then (3) click OK.

 

record macro excel 2

 

3. Make changes in the sheet that should be performed by the macro (change in fonts, colors, sizes, etc.)

4. In the Ribbon, go to View > Macros > Stop Recording.

 

record macro excel 3

 

Save a File With the .xlsm Extension

Now save the file as macro-enabled to be able to use the recorded macro later.

1. In the Ribbon, go to File > Save As.

 

excel file save as

 

2. In the save window, select file type Excel Macro-Enabled Workbook (*.xlsm), and click Save.

 

excel file save as xlsm

 

Finally, the file is saved as macro-enabled, and you can use all macros recorded within it.