{"id":6052,"date":"2015-06-14T18:23:43","date_gmt":"2015-06-14T16:23:43","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=6052"},"modified":"2015-06-14T18:24:10","modified_gmt":"2015-06-14T16:24:10","slug":"excel-vba-creer-un-lien-hypertexte","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=6052","title":{"rendered":"EXCEL &#038; VBA : cr\u00e9er un lien hypertexte"},"content":{"rendered":"<p style=\"text-align: justify;\">Les liens hypertextes font partie de notre quotidien, ils facilitent le passage d&#8217;une page \u00e0 l&#8217;autre lors de nos navigations sur internet.<\/p>\n<div id=\"attachment_6053\" style=\"width: 510px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/06\/hypertxt.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6053\" class=\"size-full wp-image-6053\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/06\/hypertxt.png\" alt=\"Exemple de lien hypertexte sur Excel\" width=\"500\" height=\"120\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/06\/hypertxt.png 500w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/06\/hypertxt-300x72.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><p id=\"caption-attachment-6053\" class=\"wp-caption-text\">Exemple de lien hypertexte sur Excel<\/p><\/div>\n<p style=\"text-align: justify;\">Sur Excel, les liens hypertextes sont aussi tr\u00e8s pratiques pour naviguer dans des classeurs comprenant de tr\u00e8s nombreux <a href=\"http:\/\/www.auditsi.eu\/?tag=onglet-de-navigation\">onglets<\/a>, par exemple dans le cas de la <a href=\"http:\/\/www.auditsi.eu\/?tag=reciprocites\">r\u00e9conciliation des comptes intercompagnie<\/a>. Il est\u00a0\u00e9galement possible de cr\u00e9er un sommaire centralisant les onglets sur une page.<\/p>\n<p style=\"text-align: justify;\">La cr\u00e9ation de liens hypertextes en VBA s&#8217;effectue \u00e0 l&#8217;aide de la commande <em>.Hyperlinks<\/em>. Cette commande \u00e9quivaut au menu Insertion \/ Lien hypertexte.<\/p>\n<p style=\"text-align: justify;\">Le code source suivant\u00a0fournit un exemple :<\/p>\n<pre class=\"lang:default decode:true\">With Selection\r\n    .Value = TexteLien\r\n    .Hyperlinks.Add Anchor:=Selection, Address:=ClasseurDestination, SubAddress:=\"'\" &amp; FeuilleDestination &amp; \"'\" &amp; \"!\" &amp; AdresseDestination, TextToDisplay:=TexteLien\r\nEnd With\r\n<\/pre>\n<p>Les param\u00e8tres sont les suivants :<\/p>\n<ul>\n<li><em>Address:=<\/em> : nom du classeur de destination,<\/li>\n<li><em>SubAddress:=<\/em> : nom de la feuille et de la cellule,<\/li>\n<li><em>TextToDisplay:=<\/em> : texte du lien.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a title=\"Programmer en VBA\" href=\"http:\/\/www.auditsi.eu\/?cat=1569\">Programmer en VBA<\/a> \/ <a title=\"S\u00e9rie d'articles d'initiation au langage Basic\" href=\"http:\/\/www.auditsi.eu\/?cat=1207\">Initiation au langage Basic<\/a> \/ <a title=\"Cr\u00e9ez votre premier programme VBA avec l'enregistreur de macros\" href=\"http:\/\/www.auditsi.eu\/?p=3995\">Cr\u00e9ez votre premier programme VBA avec l\u2019enregistreur de macros<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%26%20VBA%20%3A%20cr%C3%A9er%20un%20lien%20hypertexte\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les liens hypertextes font partie de notre quotidien, ils facilitent le passage d&#8217;une page \u00e0 l&#8217;autre lors de nos navigations sur internet. Sur Excel, les liens hypertextes sont aussi tr\u00e8s pratiques pour naviguer dans des classeurs comprenant de tr\u00e8s nombreux onglets, par exemple dans le cas de la r\u00e9conciliation des comptes intercompagnie. Il est\u00a0\u00e9galement possible &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=6052\" class=\"more-link\">Continue reading &lsquo;EXCEL &#038; VBA : cr\u00e9er un lien hypertexte&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%26%20VBA%20%3A%20cr%C3%A9er%20un%20lien%20hypertexte\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,1569,215],"tags":[1595,1633,1594,721,1641],"class_list":["post-6052","post","type-post","status-publish","format-standard","hentry","category-excel","category-programmer-en-vba","category-vba","tag-hyperlinks","tag-excel","tag-lien-hypertexte","tag-onglet-de-navigation","tag-vba"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6052"}],"version-history":[{"count":5,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6052\/revisions"}],"predecessor-version":[{"id":6058,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6052\/revisions\/6058"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}