{"id":12104,"date":"2011-12-16T14:35:00","date_gmt":"2011-12-16T14:35:00","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1001"},"modified":"2011-12-16T14:35:00","modified_gmt":"2011-12-16T14:35:00","slug":"auto-open-macro-auto-run-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/","title":{"rendered":"Auto Open Macro \/ Auto Run Macro"},"content":{"rendered":"<p>Sometimes in Excel Macro, you need to execute a Macro \/ Piece of code as soon as you open the Workbook. By Doing this no need to trigger that Macro or functions just by opening that workbook. There are two methods to achieve this.<\/p>\n<h2>Method 1: Auto Run Macro in VBA Module of the Excel: <\/h2>\n<p>Follow the below steps:<br \/>\n<strong>1.<\/strong>Open Visual Basic Editor (Alt + F11)<br \/>\n<strong>2.<\/strong>Add a Module in your VBA Project<br \/>\n<strong>3.<\/strong>In that Module Paste your Code inside <strong> Sub auto_open <\/strong><\/p>\n<pre><code class=\"language-vbnet\">\nSub auto_open()\nMsgBox (\"Welcome \" & Application.UserName)\nEnd Sub\n<\/code><\/pre>\n<div id=\"attachment_1008\" style=\"width: 615px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/12\/auto-run-vba.png\"><img decoding=\"async\" aria-describedby=\"caption-attachment-1008\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/12\/auto-run-vba.png\" alt=\"Auto Run Macro\" title=\"auto-run-vba\" width=\"605\" height=\"376\" class=\"size-full wp-image-1008\" \/><\/a><p id=\"caption-attachment-1008\" class=\"wp-caption-text\">Auto Run Macro<\/p><\/div>\n<p>\n<font color=green>Note: In the above example, as soon as you open the Workbook, One message box will open saying &#8220;Welcome <Your User Name>&#8220;<\/font><\/p>\n<p><\/p>\n<h2>Method 2: Auto Run Macro in Workbook: <\/h2>\n<p>Follow the below steps:<br \/>\n<strong>1.<\/strong>Open Visual Basic Editor (Alt + F11)<br \/>\n<strong>2.<\/strong>Double Click on <strong>&#8220;ThisWorkbook&#8221;<\/strong><br \/>\n<strong>3.<\/strong>In Visual Basic Editor paste the below code inside the <strong>Open<\/strong> Event of Workbook.<\/p>\n<pre><code class=\"language-vbnet\">\nPrivate Sub Workbook_Open()\nMsgBox (\"Welcome \" & Application.UserName)\nEnd Sub\n<\/code><\/pre>\n<div id=\"attachment_1009\" style=\"width: 615px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/12\/auto-run-workbook.png\"><img decoding=\"async\" aria-describedby=\"caption-attachment-1009\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/12\/auto-run-workbook.png\" alt=\"Auto Run Macro\" title=\"auto-run-workbook\" width=\"605\" height=\"376\" class=\"size-full wp-image-1009\" \/><\/a><p id=\"caption-attachment-1009\" class=\"wp-caption-text\">Auto Run Macro<\/p><\/div>\n<p>\n<font color=green>Note: In the above example, as soon as you open the Workbook, One message box will open saying &#8220;Welcome <Your User Name>&#8220;<\/font><\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Sometimes in Excel Macro, you need to execute a Macro \/ Piece of code as soon as you open the Workbook. By Doing this no need to trigger that Macro or functions just by opening that workbook. There are two methods to achieve this. Method 1: Auto Run Macro in VBA Module of the Excel: [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":1008,"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":[1246],"tags":[],"class_list":["post-12104","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro"],"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>Auto Open Macro \/ Auto Run Macro - Let&#039;s excel in Excel<\/title>\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\/12\/auto-open-macro-auto-run-macro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto Open Macro \/ Auto Run Macro\" \/>\n<meta property=\"og:description\" content=\"Sometimes in Excel Macro, you need to execute a Macro \/ Piece of code as soon as you open the Workbook. By Doing this no need to trigger that Macro or functions just by opening that workbook. There are two methods to achieve this. Method 1: Auto Run Macro in VBA Module of the Excel: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/\" \/>\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-12-16T14:35:00+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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Auto Open Macro \/ Auto Run Macro\",\"datePublished\":\"2011-12-16T14:35:00+00:00\",\"dateModified\":\"2011-12-16T14:35:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/\"},\"wordCount\":180,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage\"},\"thumbnailUrl\":\"\",\"articleSection\":[\"Excel Macro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/\",\"name\":\"Auto Open Macro \/ Auto Run Macro - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2011-12-16T14:35:00+00:00\",\"dateModified\":\"2011-12-16T14:35:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Auto Open Macro \/ Auto Run Macro\"}]},{\"@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":"Auto Open Macro \/ Auto Run Macro - Let&#039;s excel in Excel","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\/12\/auto-open-macro-auto-run-macro\/","og_locale":"en_US","og_type":"article","og_title":"Auto Open Macro \/ Auto Run Macro","og_description":"Sometimes in Excel Macro, you need to execute a Macro \/ Piece of code as soon as you open the Workbook. By Doing this no need to trigger that Macro or functions just by opening that workbook. There are two methods to achieve this. Method 1: Auto Run Macro in VBA Module of the Excel: [&hellip;]","og_url":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/","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-12-16T14:35:00+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":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Auto Open Macro \/ Auto Run Macro","datePublished":"2011-12-16T14:35:00+00:00","dateModified":"2011-12-16T14:35:00+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/"},"wordCount":180,"commentCount":2,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel Macro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/","url":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/","name":"Auto Open Macro \/ Auto Run Macro - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage"},"thumbnailUrl":"","datePublished":"2011-12-16T14:35:00+00:00","dateModified":"2011-12-16T14:35:00+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/auto-open-macro-auto-run-macro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Auto Open Macro \/ Auto Run Macro"}]},{"@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\/12104"}],"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=12104"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12104\/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=12104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}