{"id":12133,"date":"2012-04-10T14:53:22","date_gmt":"2012-04-10T14:53:22","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1556"},"modified":"2022-08-06T23:54:57","modified_gmt":"2022-08-06T23:54:57","slug":"assign-macro-to-hyperlink","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/","title":{"rendered":"Assigning Macro : How to assign macro to Hyperlink ?"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.16&#8243; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.17.6&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article, you are going to learn how to run a macro by using Hyperlink in Excel.<\/p>\n<h1>7 Simple Steps to Assign a Macro to a Hyperlink<\/h1>\n<p>\n<strong>Step 1. <\/strong>Select the Cell Where you want to make the Hyperlink<br \/>\n<strong>Step 2. <\/strong>Right Click &#8211;> Hyperlink&#8230;<br \/>\n<strong>Step 3. <\/strong>Enter the Address of the Same cell where you are making the hyperlink and Give the name to the Link. See the below picture:<br \/>\n<div id=\"attachment_242521\" style=\"width: 656px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-242521\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png\" width=\"646\" height=\"331\" alt=\"Assign Macro to a Hyperlink\" class=\"wp-image-242521 size-full\" srcset=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png 646w, https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1-480x246.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 646px, 100vw\" \/><p id=\"caption-attachment-242521\" class=\"wp-caption-text\">Assign Macro to a Hyperlink<\/p><\/div><\/p>\n<p><strong>Step 4. <\/strong>Click Ok.<br \/>\n<strong>Step 5. <\/strong> HyperLink is created.<br \/>\n&nbsp;<br \/>\n<strong>Note:<\/strong> Clicking on this Hyperlink, will do nothing because it is assigned to the same Cell Address.<br \/>\n&nbsp;<br \/>\n<strong>Step 6. <\/strong>Now Press Alt + F11<br \/>\n<strong>Step 7. <\/strong> Copy paste the below Code as shown in Picture<\/p>\n<pre><code class=\"language-vbnet\">\nPrivate Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)\n    'Check if the Target Address is same as you have given\n    'In the above example i have taken A4 Cell, so I am\n    'Comparing this with $A$4\n    \n    If Target.Range.Address = \"$A$4\" Then\n        'Write your all VBA Code, which you want to execute\n        'Or Call the function or Macro which you have\n        'written or recorded.\n        MsgBox \"Write your Code here to be executed\"\n        Exit Sub\n    End If\nEnd Sub\n<\/code><\/pre>\n<p>\nIn the Above Code we are comparing the Cell Address and then Executing a Set of Code or Function. There is another way of doing this also. We can Compare with the Target Name and execute the Code. In the above example as i have given the Name of the Hyperlink Target as <strong>MyMacro<\/strong>. <\/p>\n<pre><code class=\"language-vbnet\">\nPrivate Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)\n    'Check if the Target Name is same as you have given\n    'In the above example i have given the Name of the HyperLink\n    'is MyMacro.\n    \n    If Target.Name = \"mymacro\" Then\n        'Write your all VBA Code, which you want to execute\n        'Or Call the function or Macro which you have\n        'written or recorded.\n        MsgBox \"Write your Code here to be executed\"\n        Exit Sub\n    End If\nEnd Sub\n\n<\/code><\/pre>\n<div class=\"alert alert-warning\">\nTo Check out Excel Macro Tutorials, visit <strong><a href=\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\" target=\"_blank\" rel=\"noopener\">Excel Macro Tutorial<\/a><\/strong>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article, you are going to learn how to run a macro by using Hyperlink in Excel. 7 [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":242521,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article you are going to learn how to run a macro by using Hyperlink in Excel.\r\n\u00a0\r\n<strong>Follow the below Simple Steps to do so:<\/strong>\r\n<br\/>\r\n<strong>Step 1. <\/strong>Select the Cell Where you want to make the Hyperlink\r\n<strong>Step 2. <\/strong>Righ Click --> Hyperlink...\r\n<strong>Step 3. <\/strong>Enter the Address of the Same cell where you are making the hyperlink and Give name to the Link. See the below picture:\r\n\r\n\r\n<strong>Step 4. <\/strong>Click Ok.\r\n<strong>Step 5. <\/strong> HyperLink is created.\r\n\u00a0\r\n<strong>Note:<\/strong> Clicking on this Hyperlink, will do nothing because it is assigned to the same Cell Address.\r\n\u00a0\r\n<strong>Step 6. <\/strong>Now Press Alt + F11\r\n<strong>Step 7. <\/strong> Copy paste the below Code as shown in Picture\r\n<br\/>\r\n[caption id=\"attachment_1570\" align=\"aligncenter\" width=\"300\" caption=\"Run Excel Macro by Clicking on a Hyperlink\"]<a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-2.png\"><img src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-2-300x138.png\" alt=\"Run Excel Macro by Clicking on a Hyperlink\" title=\"Run Excel Macro by Clicking on a Hyperlink\" width=\"300\" height=\"138\" class=\"size-medium wp-image-1570\" \/><\/a>[\/caption]\r\n<br\/>\r\n<pre><code class=\"language-vbnet\">\r\nPrivate Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)\r\n    'Check if the Target Address is same as you have given\r\n    'In the above example i have taken A4 Cell, so I am\r\n    'Comparing this with $A$4\r\n    \r\n    If Target.Range.Address = \"$A$4\" Then\r\n        'Write your all VBA Code, which you want to execute\r\n        'Or Call the function or Macro which you have\r\n        'written or recorded.\r\n        MsgBox \"Write your Code here to be executed\"\r\n        Exit Sub\r\n    End If\r\nEnd Sub\r\n<\/code><\/pre> \r\n<br\/>\r\nIn the Above Code we are comparing the Cell Address and then Executing a Set of Code or Function. There is another way of doing this also. We can Compare with the Target Name and execute the Code. In the above Example as i have given the Name of the Hyperlink Target as <strong>MyMacro<\/strong>. \r\n\r\n<br\/>\r\n<pre><code class=\"language-vbnet\">\r\nPrivate Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)\r\n    'Check if the Target Name is same as you have given\r\n    'In the above example i have given the Name of the HyperLink\r\n    'is MyMacro.\r\n    \r\n    If Target.Name = \"mymacro\" Then\r\n        'Write your all VBA Code, which you want to execute\r\n        'Or Call the function or Macro which you have\r\n        'written or recorded.\r\n        MsgBox \"Write your Code here to be executed\"\r\n        Exit Sub\r\n    End If\r\nEnd Sub\r\n\r\n<\/code><\/pre> \r\n<br\/>\r\n\r\n<br\/>\r\n\r\n<table bgcolor=#EBDDE2 width=100% >\r\n<tr>\r\n<td align=center>\r\n\u00a0\r\nTo Check out Excel Macro Tutorials, visit <strong><a href=\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\" target=\"_blank\">Excel Macro Tutorial<\/a><\/strong>\r\n<br\/>\r\n<\/td>\r\n<\/tr>\r\n<\/table>\r\n<br\/>","_et_gb_content_width":"","footnotes":""},"categories":[1673,1246],"tags":[],"class_list":["post-12133","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions","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>Assigning Macro : How to assign macro to Hyperlink ? - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"7 Simple Steps to Assign a Macro to a Hyperlink. How to assign a macro to a hyperlink. How to run a macro by clicking on a hyperlink.\" \/>\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\/2012\/04\/assign-macro-to-hyperlink\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Assigning Macro : How to assign macro to Hyperlink ?\" \/>\n<meta property=\"og:description\" content=\"7 Simple Steps to Assign a Macro to a Hyperlink. How to assign a macro to a hyperlink. How to run a macro by clicking on a hyperlink.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/\" \/>\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=\"2012-04-10T14:53:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-06T23:54:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"646\" \/>\n\t<meta property=\"og:image:height\" content=\"331\" \/>\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\/2012\/04\/assign-macro-to-hyperlink\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Assigning Macro : How to assign macro to Hyperlink ?\",\"datePublished\":\"2012-04-10T14:53:22+00:00\",\"dateModified\":\"2022-08-06T23:54:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/\"},\"wordCount\":347,\"commentCount\":13,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png\",\"articleSection\":[\"Excel Functions\",\"Excel Macro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/\",\"name\":\"Assigning Macro : How to assign macro to Hyperlink ? - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png\",\"datePublished\":\"2012-04-10T14:53:22+00:00\",\"dateModified\":\"2022-08-06T23:54:57+00:00\",\"description\":\"7 Simple Steps to Assign a Macro to a Hyperlink. How to assign a macro to a hyperlink. How to run a macro by clicking on a hyperlink.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png\",\"width\":646,\"height\":331,\"caption\":\"Assign Macro to a Hyperlink\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Functions\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Assigning Macro : How to assign macro to Hyperlink ?\"}]},{\"@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":"Assigning Macro : How to assign macro to Hyperlink ? - Let&#039;s excel in Excel","description":"7 Simple Steps to Assign a Macro to a Hyperlink. How to assign a macro to a hyperlink. How to run a macro by clicking on a hyperlink.","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\/2012\/04\/assign-macro-to-hyperlink\/","og_locale":"en_US","og_type":"article","og_title":"Assigning Macro : How to assign macro to Hyperlink ?","og_description":"7 Simple Steps to Assign a Macro to a Hyperlink. How to assign a macro to a hyperlink. How to run a macro by clicking on a hyperlink.","og_url":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/","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":"2012-04-10T14:53:22+00:00","article_modified_time":"2022-08-06T23:54:57+00:00","og_image":[{"width":646,"height":331,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-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\/2012\/04\/assign-macro-to-hyperlink\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Assigning Macro : How to assign macro to Hyperlink ?","datePublished":"2012-04-10T14:53:22+00:00","dateModified":"2022-08-06T23:54:57+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/"},"wordCount":347,"commentCount":13,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png","articleSection":["Excel Functions","Excel Macro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/","url":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/","name":"Assigning Macro : How to assign macro to Hyperlink ? - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png","datePublished":"2012-04-10T14:53:22+00:00","dateModified":"2022-08-06T23:54:57+00:00","description":"7 Simple Steps to Assign a Macro to a Hyperlink. How to assign a macro to a hyperlink. How to run a macro by clicking on a hyperlink.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/Assign-Macro-to-a-Hyperlink-1.png","width":646,"height":331,"caption":"Assign Macro to a Hyperlink"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/assign-macro-to-hyperlink\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Functions","item":"https:\/\/vmlogger.com\/excel\/excel-functions\/"},{"@type":"ListItem","position":3,"name":"Assigning Macro : How to assign macro to Hyperlink ?"}]},{"@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\/12133"}],"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=12133"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12133\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242521"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}