How to Save Macro in Excel (with Easy Steps)

If you are tired of performing the same series of tasks repeatedly, then Excel Macro is here to save you from this tedious and monotonous work. Excel Macro is a record of an action or a series of actions that can be saved and later you can perform this series of tasks as many times as you like by simply running the Macro. So, let’s explore how we can save a Macro.

5 Easy Steps to Save Macro in Excel

In this section, we will demonstrate how to save macro. Follow the steps below.

Step 01: Activate Record Macro Option

  • First, we have to record a macro. To do that, go to the Developer tab and click on Record Macro.

How to Save Macro in Excel

  • After clicking on the Record Macro, you will see a dialogue box like this.

How to Save Macro in Excel

Step 02: Input Macro Name, Short Key, and Store Location

  • In the Record Macro Dialogue Box, there are 3 fields you need to fill.
    • In the Macro name box, give a suitable name for the macro (The name must not have any space).
    • In the Shortcut key box, give a shortcut key that you will use for running the macro.
    • In the Store macro box, there are three options.
        1. Choose Personal Macro Workbook if you want to run the Macro for every workbook.
        2. Choose New Workbook if you need to run the macro in a new workbook.
        3. Choose This Workbook if you want to run the macro in this workbook only.

How to Save Macro in Excel

Step 03: Perform a Series of Actions to Record Macro

  • For illustration purposes, we are showing an Example Macro. In this macro, we will perform 3 tasks.
        1. Change the background color of any selected cell to green.
        2. Change the font size to 14 and
        3. Make the font bold.
  • So, we select a cell, then go to the Developer Tab, and click on Record Macro.
  • Now in the Dialogue Box, we input the following.
    How to Save Macro in Excel
  • Now we go to the Home tab and perform the 3 tasks mentioned above sequentially.

How to Save Macro in Excel

Step 04: Stop Recording of Macro

  • Now we again go to the Developer tab and click on Stop Recording.

  • Consequently, our macro has been recorded.
  • Now, we select another cell and run the macro by clicking ctrl+f.

  • And we get the desired result.

Step 05: Save Excel File in XLSM Format

  • Now, to run the macro again even after closing the file, we need to save the file as an xlsm To do so, first, go to the File Tab.

How to Save Macro in Excel

  • You should see a new wind like this below.

How to Save Macro in Excel

  • Now go to Save As. In the File type drop-down menu. Select Excel Macro-Enabled Workbook(*.xlsm). Then click Save.
  • Now even if you close and reopen the workbook, you can still run the macro by clicking ctrl+f.

Things to Remember

  • If you don’t have the Developer Tab enabled, you have to enable it first. Check this article for enabling Developer Tab
  • You must perform the tasks sequentially while recording Macro. Otherwise, the result might be different than expected.
  • If your excel file is xlsx type, you don’t have to save this as an xlsm file to enable the Macro as macro is by default enabled in the xlsx file.


If you find this article helpful, please share this with your friends. Moreover, do let us know if you have any further queries.

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

1 Comment

Leave a reply

Advanced Excel Exercises with Solutions PDF