{"id":474554,"date":"2022-07-15T21:00:52","date_gmt":"2022-07-15T18:00:52","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-enable-macros-in-microsoft-excel\/"},"modified":"2022-07-15T21:00:52","modified_gmt":"2022-07-15T18:00:52","slug":"how-to-enable-macros-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-enable-macros-in-microsoft-excel\/","title":{"rendered":"#How to Enable Macros in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a27fbdf3c3b5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a27fbdf3c3b5\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-enable-macros-in-microsoft-excel\/#%E2%80%9CHow_to_Enable_Macros_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Enable Macros in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-enable-macros-in-microsoft-excel\/#Be_Smart_When_Enabling_Macros\" >Be Smart When Enabling Macros<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-enable-macros-in-microsoft-excel\/#How_to_Turn_On_Macros_for_a_Specific_Excel_Spreadsheet\" >How to Turn On Macros for a Specific Excel Spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-enable-macros-in-microsoft-excel\/#How_to_Enable_Macros_for_All_Excel_Spreadsheets\" >How to Enable Macros for All Excel Spreadsheets<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-enable-macros-in-microsoft-excel\/#Activate_Macros_in_Excel_on_Windows\" >Activate Macros in Excel on Windows<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-enable-macros-in-microsoft-excel\/#Activate_Macros_in_Excel_on_Mac\" >Activate Macros in Excel on Mac<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Enable_Macros_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Enable Macros in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo.\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Using Microsoft Excel macros, you can run a prerecorded set of steps to automate many of your repetitive tasks. You\u2019ll have to turn on the feature before you can use it. We\u2019ll show you how to activate macros on a per-spreadsheet basis as well as for all spreadsheets in Excel.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Be_Smart_When_Enabling_Macros\"><\/span>Be Smart When Enabling Macros<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/171993\/macros-explained-why-microsoft-office-files-can-be-dangerous\/\">Enabling macros is not always safe and you should only use them when you\u2019re sure of the source of your spreadsheets. Good macros save you time by automating your tasks, but there are bad macros that can harm your machine.<\/p>\n<p>For example, if you\u2019ve got your spreadsheet from an unknown source, you shouldn\u2019t trust it to run any macros as you aren\u2019t sure what it will end up doing. However, if you know the sender and you trust them, then it should be okay to allow your spreadsheets to execute macros.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Turn_On_Macros_for_a_Specific_Excel_Spreadsheet\"><\/span>How to Turn On Macros for a Specific Excel Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To enable macros in a specific spreadsheet and not all spreadsheets, then first, open your spreadsheet with Microsoft Excel.<\/p>\n<p>When your macro-enabled spreadsheet opens, <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/250834\/how-to-disable-the-security-warning-message-bar-in-microsoft-office-programs\/\">Excel will display a message at the top of the spreadsheet content. To allow this file to run macros, then next to the message, click \u201cEnable Content.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-812597\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/1-enable-macro-one-spreadsheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Enable Content&quot; at the top.\" width=\"650\" height=\"296\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Excel will allow the current file to execute its macros, and you\u2019re all set.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Disable the Security Warning Message Bar in Microsoft Office Programs<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Enable_Macros_for_All_Excel_Spreadsheets\"><\/span>How to Enable Macros for All Excel Spreadsheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It\u2019s not recommended to activate macros for all your spreadsheets, but if you\u2019re sure you\u2019ll only open safe and trusted files, then you can turn on the option as follows.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Activate_Macros_in_Excel_on_Windows\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Activate Macros in Excel on Windows<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you\u2019re a Windows user, first, launch Microsoft Excel on your PC.<\/p>\n<p>In Excel\u2019s left sidebar, click \u201cOptions.\u201d If you\u2019re on a spreadsheet screen, then choose File &gt; Options instead.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-812598\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/2-excel-options.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose &quot;Options&quot; from the left sidebar.\" width=\"650\" height=\"361\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the \u201cExcel Options\u201d window, in the left sidebar, click \u201cTrust Center.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-812599\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/3-excel-trust-center.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Trust Center&quot; from the left sidebar.\" width=\"650\" height=\"450\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the right pane, click the \u201cTrust Center Settings\u201d button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-812600\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/4-excel-trust-center-settings.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose &quot;Trust Center Settings&quot; on the right.\" width=\"650\" height=\"225\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see a \u201cTrust Center\u201d window. In the left sidebar of this window, click \u201cMacro Settings.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-812601\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/5-excel-macro-settings.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Macro Settings&quot; on the left.\" width=\"650\" height=\"321\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the right pane, activate the \u201cEnable VBA Macros (Not Recommended; Potentially Dangerous Code Can Run)\u201d option. Then select \u201cOK\u201d at the bottom.<\/p>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> In the future, to disable macros for all spreadsheets, select an appropriate option on this screen.<\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-812602\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/6-enable-all-excel-macros.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"497\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select \u201cOK\u201d at the bottom of the \u201cExcel Options\u201d window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-812603\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/7-save-excel-macro-settings.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"284\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And that\u2019s it. Excel will now allow any spreadsheet to run macros.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Activate_Macros_in_Excel_on_Mac\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_4\">Activate Macros in Excel on Mac<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To turn on Excel macros on your Mac, first, launch the Excel app.<\/p>\n<p>In Excel, click Excel &gt; Preferences &gt; Security &amp; Privacy. Then, turn on the \u201cEnable All Macros (Not Recommended; Potentially Dangerous Code Can Run)\u201d option.<\/p>\n<p>You\u2019re done.<\/p>\n<p>And that\u2019s how you allow your spreadsheets to run codes and automate your tedious tasks.<\/p>\n<hr\/>\n<p>If you\u2019d like to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/162975\/geek-school-learn-how-to-use-excel-macros-to-automate-tedious-tasks\/\">learn more about Excel macros, then check out our dedicated guide on the topic. It will walk you through the process of creating a macro with an example.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>Learn How to Use Excel Macros to Automate Tedious Tasks<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/812574\/enable-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Enable Macros in Microsoft Excel&#8221; Using Microsoft Excel macros, you can run a prerecorded set of steps to automate many of your repetitive tasks. You\u2019ll have to turn on the feature before you can use it. We\u2019ll show you how to activate macros on a per-spreadsheet basis as well as for all spreadsheets&#8230;<\/p>\n","protected":false},"author":1,"featured_media":474555,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-474554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/474554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=474554"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/474554\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/474555"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=474554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=474554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=474554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}