{"id":8843,"date":"2024-12-17T20:33:41","date_gmt":"2024-12-17T20:33:41","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=8843"},"modified":"2024-12-17T20:36:48","modified_gmt":"2024-12-17T20:36:48","slug":"how-to-enable-macros-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel","title":{"rendered":"How to Enable Macros in Excel Windows\/Mac?"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">In MS Excel, macros are the feature that is used when developing spreadsheets. On the other hand, we can say, that macros are automated actions or scripts in that save time by performing repetitive tasks. However, it is important to enable this feature to improve the spreadsheet\u2019s functionality. In this blog, I will show you a complete step-by-step on <strong>how to enable macros in Excel Windows 10\/11<\/strong>.<!--more--><\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To recover corrupted Excel file data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>How to Enable Macros in Excel Windows 10?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Follow the below methods to enable macros in the Excel sheet.<\/p>\n<h3 style=\"text-align: left;\"><strong>Method 1: How to Enable Macros in Excel Windows 10 via Backstage View<\/strong><\/h3>\n<p style=\"text-align: justify;\">The very first and easy solution you can try is turning on macros via Office Backstage view. Follow the below steps to do so:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Navigate to the\u00a0<strong><em>File <\/em><\/strong>menu &gt;&gt; click\u00a0<strong>Info<\/strong>\u00a0option left menu.<\/li>\n<li>Under\u00a0<em>Security Warning<\/em>part, you have to click on the\u00a0<em>Enable Content<\/em>\u00a0option &gt;&gt;\u00a0<strong>Enable All Content<\/strong>.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>Method 2: Turn ON Macros for One Session<\/strong><\/h3>\n<p style=\"text-align: justify;\">Sometimes, you may need to enable Excel macros for a single time. Thus, if you want to do so and make this workbook a trusted document, follow the below instructions carefully:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Go to the <em><strong>File<\/strong> <\/em>menu &gt;\u00a0<em>Info<\/em>.<\/li>\n<li style=\"text-align: left;\">Under the\u00a0<em>Security Warning <\/em>section, click on the option\u00a0\u201c<em>Enable Content\u201d<\/em>\u00a0&gt;\u00a0<strong>Advanced Options<\/strong>.<\/li>\n<li style=\"text-align: left;\">Under the <em>Microsoft Office Security Options <\/em>dialog box, you have to\u00a0<strong>Enable content for this session<\/strong> &gt;&gt; click\u00a0<em>OK<\/em>.<\/li>\n<li style=\"text-align: left;\">This enables macros for one time.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Please note<\/span>:<\/strong> Once you close your document, and then open it again, the caution will appear again.<\/p>\n<h3 style=\"text-align: left;\"><strong>Method 3: Enable VBA Codes via Trust Center<\/strong><\/h3>\n<p style=\"text-align: justify;\">As many of you are unaware of the fact that MS Excel allows or disallows the macro to run based on the macro setting chosen in the\u00a0<strong>Trust Center<\/strong>. However, to get VBA enabled in all MS Excel documents by default, follow the below steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Click <em>File<\/em>tab &gt;&gt;\u00a0<em>Options<\/em>.<\/li>\n<li style=\"text-align: left;\">After this, you have to select <em>Trust Center<\/em> &gt;&gt;\u00a0<strong>Trust Center Settings\u2026\u00a0<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6051 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/12\/12.png\" alt=\"Trust Center Settings\" width=\"846\" height=\"467\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/12\/12.png 846w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/12\/12-300x166.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/12\/12-768x424.png 768w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Under\u00a0<em>Trust\u00a0<\/em><span style=\"box-sizing: border-box; margin: 0; padding: 0; text-align: left;\"><em>Center\u00a0<\/em>dialog<\/span>\u00a0box, you have to click on the\u00a0<em>Macro Settings<\/em>\u00a0on the left, choose\u00a0<strong>Enable all macros<\/strong>\u00a0&gt;&gt; hit\u00a0<em>OK<\/em>.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">That\u2019s all!<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Enable Macros in Excel Sheet on Mac?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Not only Windows but Excel for Mac users also enable or disable macros to enhance the spreadsheet functionality. Here are the complete steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li>On Excel PC, open\u00a0<strong>Excel<\/strong>.<\/li>\n<li style=\"text-align: left;\">Choose\u00a0<strong>Excel <\/strong>at the top &amp; select\u00a0<strong>Preferences<\/strong>.<\/li>\n<li style=\"text-align: left;\">Choose\u00a0<strong>Security <\/strong>in the\u00a0<strong>Sharing and Privacy<\/strong>.<\/li>\n<li style=\"text-align: left;\">Now, you have to check\u00a0<strong>Macro Security <\/strong>option &amp; click a radio option beside the relevant option.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>Repair Corrupted Workbook: Use MS Excel Repair Tool<\/strong><\/h2>\n<p style=\"text-align: justify;\">Excel is a daily use program and it is common to encounter errors or issues while handling it. If you face any errors or issue due to the Excel file corruption, you can use the <strong><a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\">MS Excel Repair Tool<\/a><\/strong>. This is an advanced software that allows repairing, corrupt inaccessible files in Excel, and some kind of Excel errors.<\/p>\n<p style=\"text-align: justify;\">Furthermore, it is very easy to use and supports all Excel versions.<\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n<p style=\"text-align: justify;\">        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Why Can&#039;t I Enable Macros in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou might be unable to enable macros due to faulty Excel add-ins.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Enable Macro Developer in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf the Developer tab is missing from the top of the Excel ribbon, then do the following things: Select Excel &gt;&gt; Preferences option &gt; Ribbon &amp; Toolbar. In the Customize the Ribbon, choose Main Tabs &gt;&gt; check Developer.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do You Unblock Macros in Windows 11?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo unlock macros in Windows 11, you have to right-click on the Excel file &gt;&gt; choose properties. After that, you should check the checkbox, which says \u2018<strong>unblock<\/strong>\u2019, and press <strong>OK<\/strong>.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Check If Macros Are Enabled in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIn order to check if macros are enabled, open Excel and Press Alt+F11.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Why Can't I Enable Macros in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You might be unable to enable macros due to faulty Excel add-ins.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Enable Macro Developer in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If the Developer tab is missing from the top of the Excel ribbon, then do the following things: Select Excel &gt;&gt; Preferences option &gt; Ribbon &amp; Toolbar. In the Customize the Ribbon, choose Main Tabs &gt;&gt; check Developer.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do You Unblock Macros in Windows 11?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To unlock macros in Windows 11, you have to right-click on the Excel file &gt;&gt; choose properties. After that, you should check the checkbox, which says \u2018<strong>unblock<\/strong>\u2019, and press <strong>OK<\/strong>.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How to Check If Macros Are Enabled in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"In order to check if macros are enabled, open Excel and Press Alt+F11.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Final Thoughts<\/strong><\/h2>\n<p style=\"text-align: justify;\">Enabling macros in the Excel aids in streamlining your work &amp; increase efficiency. Therefore, always ensure you use macros reliably and only with trusted files. Follow this guide step by step on <strong>how to enable macros in Excel sheet <\/strong>and take full advantage of Excel\u2019s features.<\/p>\n<p style=\"text-align: justify;\">I hope you liked this post!<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>External References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In MS Excel, macros are the feature that is used when developing spreadsheets. On the other hand, we can say, &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Enable Macros in Excel Windows\/Mac?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#more-8843\" aria-label=\"Read more about How to Enable Macros in Excel Windows\/Mac?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":8844,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[1882,1881],"class_list":["post-8843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-how-to-enable-macros-in-excel-sheet","tag-how-to-enable-macros-in-excel-windows-10","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Enable Macros in Excel Windows\/Mac?<\/title>\n<meta name=\"description\" content=\"Learn how to enable macros in Excel Windows 10\/11 using 3 best methods. Also, learn how to enable macros in Excel sheet on Mac easily.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Enable Macros in Excel Windows\/Mac?\" \/>\n<meta property=\"og:description\" content=\"Learn how to enable macros in Excel Windows 10\/11 using 3 best methods. Also, learn how to enable macros in Excel sheet on Mac easily.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-17T20:33:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-17T20:36:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/12\/how-to-enable-macros-in-Excel-Windows-10-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"309\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Enable Macros in Excel Windows\\\/Mac?\",\"datePublished\":\"2024-12-17T20:33:41+00:00\",\"dateModified\":\"2024-12-17T20:36:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel\"},\"wordCount\":755,\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/how-to-enable-macros-in-Excel-Windows-10-1.png\",\"keywords\":[\"how to enable macros in Excel sheet\",\"how to enable macros in Excel Windows 10\"],\"articleSection\":[\"Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel\",\"name\":\"How to Enable Macros in Excel Windows\\\/Mac?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/how-to-enable-macros-in-Excel-Windows-10-1.png\",\"datePublished\":\"2024-12-17T20:33:41+00:00\",\"dateModified\":\"2024-12-17T20:36:48+00:00\",\"description\":\"Learn how to enable macros in Excel Windows 10\\\/11 using 3 best methods. Also, learn how to enable macros in Excel sheet on Mac easily.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel#primaryimage\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/how-to-enable-macros-in-Excel-Windows-10-1.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/how-to-enable-macros-in-Excel-Windows-10-1.png\",\"width\":550,\"height\":309,\"caption\":\"how to enable macros in Excel Windows 10\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-enable-macros-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Enable Macros in Excel Windows\\\/Mac?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyanka-sahu-2794a1242\"],\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/author\\\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Enable Macros in Excel Windows\/Mac?","description":"Learn how to enable macros in Excel Windows 10\/11 using 3 best methods. Also, learn how to enable macros in Excel sheet on Mac easily.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Enable Macros in Excel Windows\/Mac?","og_description":"Learn how to enable macros in Excel Windows 10\/11 using 3 best methods. Also, learn how to enable macros in Excel sheet on Mac easily.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2024-12-17T20:33:41+00:00","article_modified_time":"2024-12-17T20:36:48+00:00","og_image":[{"width":550,"height":309,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/12\/how-to-enable-macros-in-Excel-Windows-10-1.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Enable Macros in Excel Windows\/Mac?","datePublished":"2024-12-17T20:33:41+00:00","dateModified":"2024-12-17T20:36:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel"},"wordCount":755,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/12\/how-to-enable-macros-in-Excel-Windows-10-1.png","keywords":["how to enable macros in Excel sheet","how to enable macros in Excel Windows 10"],"articleSection":["Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel","name":"How to Enable Macros in Excel Windows\/Mac?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/12\/how-to-enable-macros-in-Excel-Windows-10-1.png","datePublished":"2024-12-17T20:33:41+00:00","dateModified":"2024-12-17T20:36:48+00:00","description":"Learn how to enable macros in Excel Windows 10\/11 using 3 best methods. Also, learn how to enable macros in Excel sheet on Mac easily.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/12\/how-to-enable-macros-in-Excel-Windows-10-1.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/12\/how-to-enable-macros-in-Excel-Windows-10-1.png","width":550,"height":309,"caption":"how to enable macros in Excel Windows 10"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-enable-macros-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Enable Macros in Excel Windows\/Mac?"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/8843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=8843"}],"version-history":[{"count":1,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/8843\/revisions"}],"predecessor-version":[{"id":8845,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/8843\/revisions\/8845"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/8844"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=8843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=8843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=8843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}