How to Make a Macro Enabled Workbook in Excel (3 Simple Ways)

Visual Basic for Applications in short VBA is the programming language related to Microsoft Excel. Sometimes this feature remains turned off for a workbook. In order to have enabled macro Excel workbook, there are some easy ways that we can follow. I am going to explain three simple and easy ways to enable macro in Excel workbook. I hope it will be helpful for Excel users.


Introduction of Excel Macro

A Macro is a set of instructions that can be used to automate a task or series of tasks. Macro Programming in Visual Basic for Applications is used in Microsoft Office applications (VBA). Numerous operations, including document formatting, computations, and the insertion of text or images, can be automated using macros. Other programs, including Microsoft Word or PowerPoint, can also be controlled by macros.


Excel Macro Enabled Workbook Extension

In terms of working with Excel, we use the file extension .xlsx. If the file is saved with this extension, the file won’t support Macro which is a programming language. Macro-enabled workbooks have the file extension .xlsm. You need to change your file extension from .xlsx to .xlsm if you want to enable macro in a file.


3 Simple Ways to Make a Macro Enabled Workbook in Excel

1. Changing File Extension to Enable Macro

We often save our Excel file in .xlsx mode. If the file is saved in this extension, Macro won’t work. So, changing the extension to .xlsm is a possible way to enable Macro in Excel Workbook. In order to change the extension, you need to follow the following procedure.

Steps:

  • First of all, go to the File tab.
  • Next, select the Save As option.
  • Then, choose your file location.
  • Finally, pick Excel Macro-Enabled Workbook (*.xlsm) from Save As Type option.

This will enable Macro in the Excel Workbook. Any Macros that were previously set, will work just fine. Furthermore, we can even write the additional VBA code in the module.


2. Enabling Macros From Trust Center

We can try by checking the Enable VBA Macros option from the Trust Center to enable Macros in Excel Workbook. This is another very simple way to do so.

Steps:

  • Click on the File tab first.
  • Next, select Options.

Macro Enabled Workbook From Trust Center

Excel Options named box will appear.

  • Next, click on Trust Center.
  • Go to Trust Center Settings…

A Trust Center wizard will come forward.

  • After that, click on Macro Settings.
  • From the available option, check the Enable VBA macros (not recommended; potentially dangerous code can run) box.
  • Click OK.

Enabling Macros From Trust Center

  • Finally, click OK again to finish the process.

I hope this will enable macro in the Excel workbook.


3. Changing File Property to Enable Macro in Excel Workbook

In the recent security update process, a shared Excel file with Macro needs some property modification to enable Macro. This might be a reason which disables the Macro in Excel workbook.

Steps:

  • Right-Click on the mouse putting the cursor on the Excel file.
  • Next, go to the Properties option.

Changing File Property to get Macro Enabled Workbook

  • From the General tab, check the Unblock box.
  • Following, press on Apply.
  • Finally, click on OK to finish the process.

This might be another way to enable the Macro in Excel workbook.


Conclusion

In the above section of this article, I have tried to explain three simple and easy ways to enable macro in Excel workbook. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

1 Comment

Leave a reply

ExcelDemy
Logo