How to Enable Macros in Microsoft Excel

To enable macros in Excel, you just need to access the Trust Center and change the configuration. This is very straightforward; just consider that when you enable macros, any file will be able to run code on your computer, which is potentially dangerous.

Steps

  1. Image titled Enable Macros in Microsoft Excel Step 1
    1
    Go to the File menu in Excel.
  2. Image titled Enable Macros in Microsoft Excel Step 2
    2
    Scroll down to Options menu.
    Advertisement
  3. Image titled Enable Macros in Microsoft Excel Step 3
    3
    Select Trust Center in the window that pops up.
  4. Image titled Enable Macros in Microsoft Excel Step 4
    4
    Click the "Trust Center Settings" button on the bottom right of the "Trust Center" tab.
  5. Image titled Enable Macros in Microsoft Excel Step 5
    5
    On the Trust Center choose "Macro Settings" tab (left).
  6. Image titled Enable Macros in Microsoft Excel Step 6
    6
    Enable all macros.
  7. Image titled Enable Macros in Microsoft Excel Step 7
    7
    Click "OK", then "OK" again to apply.
    8. Advertisement

You Might Also Like

Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Create a Graph in Excel
How to
Create a Graph in Excel
Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
How to
Unhide Rows in Excel
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
Convert Excel to Word3 Easy Ways to Convert Microsoft Excel Data to Word
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Merge Cells in ExcelHow to Merge Cells in Microsoft Excel: A Quick Guide
Calculate Age on ExcelHow to Calculate Age on Microsoft Excel Using Functions
Find Duplicates in Excel
How to
Find Duplicates in Excel
Link Sheets in Excel
How to
Link Sheets in Excel
Advertisement

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 69,514 times.
How helpful is this?
Co-authors: 3
Updated: May 24, 2017
Views: 69,514
Categories: Microsoft Excel
Advertisement