This will enable Macro in the Excel Workbook. First, go to the File tab > select the Save As option > choose your file location > pick Excel Macro-Enabled Workbook (*.xlsm) from the Save As Type option.In order to change the extension, you need to follow the following procedure. xlsm is a possible way to enable Macro in Excel workbook. If the file is saved in this extension, Macro won’t work.
So, use the exact one for your Excel version.ġ. The following methods will vary with different versions of Excel.
Also, how to open an enabled macro workbook. Now, I will explain how to enable the macro. xlsm if you want to enable macro in a file.Įxcel Macro Enabled Workbook: 5 Simple Ways to Open You need to change your file extension from. Macro-enabled workbooks have the file extension. If you save the file with this extension, the file won’t support Macro which is a programming language. In terms of working with Excel, we use the file extension. Other programs, including Microsoft Word or PowerPoint, can also be controlled by macros. You can automate numerous operations, including document formatting, computations, and the insertion of text or images, using macros. Macro Programming in Visual Basic for Applications is used in Microsoft Office applications ( VBA). A Macro is a set of instructions that can be used to automate a task or series of tasks.