{"id":12075,"date":"2011-11-03T19:45:36","date_gmt":"2011-11-03T19:45:36","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=215"},"modified":"2022-08-07T01:03:24","modified_gmt":"2022-08-07T01:03:24","slug":"macro-security","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/","title":{"rendered":"Macro Security"},"content":{"rendered":"<p>Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA.<br \/>\nMacro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.<br \/>\n<a href =\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#excel-2003\">Excel 2003<\/a> | <a href =\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#excel-2007\">Excel 2007<\/a><br \/>\n<a NAME=\"excel-2003\"><font size =4 color=#287671><br \/>\nExcel 2003<\/font><br \/>\n<font color=black><br \/>\n<!--more--><br \/>\n1. Click on Tools<br \/>\n2. Go to Macro<br \/>\n3. Click on Security.<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/macro-security-excel-2003.jpg\" alt=\"\" \/><\/p>\n<p>4. Here you have 4 options.<br \/>\n    i) Very High will disable all macros.<br \/>\n    ii) High level will only allow macros which are signed by an acknowledged trusted source.<br \/>\n    iii) Medium will confirm before running the running.<br \/>\n    iv) Low will enable all macros without any condition.<br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Security-levels-2003.jpg\" alt=\"\" \/><br \/><\/a><\/font><br \/>\n<A NAME=\"excel-2007\"><font size =3 color=#287671><br \/>\nExcel 2007<\/font><\/p>\n<p>1. Go to &#8220;Developer Tab&#8221;<br \/>\n2. Click on Macro Security<br \/>\n3. Go to Trust Center<br \/>\n4. Click on Macro Settings <br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/macro-security-excel-2010-2007.png\" alt=\"\" \/><br \/>\nHere also we have 4 options:<br \/>\n     i) Disable All macro without notification: This will not allow to run any of the Macro.<br \/>\n     ii) Disable Macro with notification: This will not allow to run the macro, but it will show a notification.<br \/>\n     iii) Disable All Macro except Digitally signed Macro: This allows only those macros which are digitally signed.<br \/>\n     iv) Enable All Macros: This allows to run all the macros without any notification. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/security-level-options-excel-2007-2010.png\" alt=\"\" \/><br \/><\/a><\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":221,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1674],"tags":[],"class_list":["post-12075","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-macro-basics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Macro Security - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Macro Security\" \/>\n<meta property=\"og:description\" content=\"Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-03T19:45:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-07T01:03:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Macro Security\",\"datePublished\":\"2011-11-03T19:45:36+00:00\",\"dateModified\":\"2022-08-07T01:03:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/\"},\"wordCount\":207,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage\"},\"thumbnailUrl\":\"\",\"articleSection\":[\"Excel Macro Basics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/\",\"name\":\"Macro Security - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2011-11-03T19:45:36+00:00\",\"dateModified\":\"2022-08-07T01:03:24+00:00\",\"description\":\"Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro Basics\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-macro-basics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Macro Security\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Macro Security - Let&#039;s excel in Excel","description":"Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.","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:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/","og_locale":"en_US","og_type":"article","og_title":"Macro Security","og_description":"Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.","og_url":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-11-03T19:45:36+00:00","article_modified_time":"2022-08-07T01:03:24+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Macro Security","datePublished":"2011-11-03T19:45:36+00:00","dateModified":"2022-08-07T01:03:24+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/"},"wordCount":207,"commentCount":3,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel Macro Basics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/","url":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/","name":"Macro Security - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage"},"thumbnailUrl":"","datePublished":"2011-11-03T19:45:36+00:00","dateModified":"2022-08-07T01:03:24+00:00","description":"Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see how we can change the macro security settings in all versions of MS Excel like 2003, 2007 and 2010.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/macro-security\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro Basics","item":"https:\/\/vmlogger.com\/excel\/excel-macro-basics\/"},{"@type":"ListItem","position":3,"name":"Macro Security"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12075"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12075"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12075\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}