Skip to Content

Log in / Sign up

wikiHow is where trusted research and expert knowledge come together. Learn why people trust wikiHow

How to Enable Macros in Microsoft Excel

Download Article

Last Updated: May 24, 2017

Download Article

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

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/83\/Enable-Macros-in-Microsoft-Excel-Step-1.jpg\/v4-460px-Enable-Macros-in-Microsoft-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/8\/83\/Enable-Macros-in-Microsoft-Excel-Step-1.jpg\/aid7182342-v4-728px-Enable-Macros-in-Microsoft-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9f\/Enable-Macros-in-Microsoft-Excel-Step-2.jpg\/v4-460px-Enable-Macros-in-Microsoft-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/9\/9f\/Enable-Macros-in-Microsoft-Excel-Step-2.jpg\/aid7182342-v4-728px-Enable-Macros-in-Microsoft-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

Advertisement
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/03\/Enable-Macros-in-Microsoft-Excel-Step-3.jpg\/v4-460px-Enable-Macros-in-Microsoft-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/0\/03\/Enable-Macros-in-Microsoft-Excel-Step-3.jpg\/aid7182342-v4-728px-Enable-Macros-in-Microsoft-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/68\/Enable-Macros-in-Microsoft-Excel-Step-4.jpg\/v4-460px-Enable-Macros-in-Microsoft-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/6\/68\/Enable-Macros-in-Microsoft-Excel-Step-4.jpg\/aid7182342-v4-728px-Enable-Macros-in-Microsoft-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fa\/Enable-Macros-in-Microsoft-Excel-Step-5.jpg\/v4-460px-Enable-Macros-in-Microsoft-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/f\/fa\/Enable-Macros-in-Microsoft-Excel-Step-5.jpg\/aid7182342-v4-728px-Enable-Macros-in-Microsoft-Excel-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b9\/Enable-Macros-in-Microsoft-Excel-Step-6.jpg\/v4-460px-Enable-Macros-in-Microsoft-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/b\/b9\/Enable-Macros-in-Microsoft-Excel-Step-6.jpg\/aid7182342-v4-728px-Enable-Macros-in-Microsoft-Excel-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/90\/Enable-Macros-in-Microsoft-Excel-Step-7.jpg\/v4-460px-Enable-Macros-in-Microsoft-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/9\/90\/Enable-Macros-in-Microsoft-Excel-Step-7.jpg\/aid7182342-v4-728px-Enable-Macros-in-Microsoft-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Advertisement

Tips

Keep in mind that enabling all macros might be dangerous if you don't handle with care which files you open.

Thanks
Helpful 0 Not Helpful 1

Submit a Tip

All tip submissions are carefully reviewed before being published

Thanks for submitting a tip for review!

Advertisement

You Might Also Like

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 81,919 times.

How helpful is this?

Co-authors: 3

Updated: May 24, 2017

Views: 81,919

Categories: Microsoft Excel

Thanks to all authors for creating a page that has been read 81,919 times.

Is this article up to date?

Advertisement

wikiHow Tech Help Pro:

Level up your tech skills and stay ahead of the curve

X

-

-

372

.mwimg a.image{display:none}#header_logo{display:none}#cse-search-box{display:none}#cse-search-box-noscript{display:block !important}#cse-search-box-noscript .cse_q{color:#FFF;background-color:#B3CE9C}.wh_search .cse_q{width:88%}#mw-mf-main-menu-button{display:none;visibility:hidden}.header .search{display:none}#search_footer .cse_sa{background-image:url(/extensions/wikihow/mobile/images/white_mag.png);background-size:22px}.related_box{display:block;background:#EEE;border:5px solid #FFF;vertical-align:bottom;width:127px;background-size:180px;float:left;height:120px;position:relative}.related_box p{line-height:15px !important;font-size:13px;background-color:rgba(67,95,44,.4);color:#FFF;font-weight:bold;padding:8px;margin:0 !important;position:absolute;bottom:0}#noscript_header_logo{display:table-cell;vertical-align:middle;background-position:50% 77%;background-repeat:no-repeat;background-image:url(/extensions/wikihow/mobile/images/wikihow_logo_230.png);background-size:105px;width:auto;height:51px;padding:0 14px}.articleinfo{display:none}#iorg_free_data{z-index:50;width:100%;position:fixed}#ara_recommendations{display:none}

Design a Mobile Website

View Site in Mobile | Classic

Share by: