How to Create a Macro-Enabled Workbook

Welcome to my Tutorials. 


In this Tutorial I will teach you how to create a Macro-Enabled Workbook within Excel 2010. 


A Macro-Enabled Workbook is used when the user wants to create and use macros within their workbook.  


Step 1: Begin by opening Excel 2010.

If you already have Excel 2010 open you don't need worry about opening it again.

Step 2: Create a macro

Technically you don't need a macro to create a Macro-Enabled Workbook. However, why would you make it Macro-Enabled if you had no macros?

For the purpose of this tutorial I will assume that you already know how to create a macro. If you need help creating a macro feel free to read my How to Create a Macro tutorial.

Now that we have Excel 2010 open and have created a macro we are ready to save the workbook as a Macro-Enabled Workbook.

Step 3: Save the workbook as Macro-Enabled Workbook

Open File menu.

Select Save (This will open the Save As window). 

   

 

Select File Address.

 

Enter File Name.

Change the Save As Type to Macro-Enabled Workbook.

Select Save.

Congratulations.  You have created a Macro-Enabled Workbook. For a complete list of all my macro tutorials open Workbook Tutorials.