How to Save a Macro-Enabled Workbook in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on June 1, 2023

This tutorial demonstrates 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 use VBA macros to automate tasks. If you are working with the 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); it’s already macro-enabled.

Record 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

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

record macro excel 2

  1. Make changes in the sheet that should be performed by the macro (change in fonts, colors, sizes, etc.)
  2. 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

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

excel file save as xlsm

AI Formula Generator

Try for Free

See all How-To Articles