{"id":5901,"date":"2015-02-15T13:20:18","date_gmt":"2015-02-15T12:20:18","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=5901"},"modified":"2015-02-15T13:21:06","modified_gmt":"2015-02-15T12:21:06","slug":"excel-vba-affecter-une-macro-a-un-bouton-de-commande","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=5901","title":{"rendered":"Excel &#038; VBA : affecter une macro \u00e0 un bouton de commande"},"content":{"rendered":"<p style=\"text-align: justify;\">Pour d\u00e9clencher manuellement l&#8217;ex\u00e9cution une macro VBA, il y a deux solutions. La premi\u00e8re consiste \u00e0 la s\u00e9lectionner dans la liste des macros puis \u00e0 l&#8217;ex\u00e9cuter. La deuxi\u00e8me consiste \u00e0 affecter l&#8217;ex\u00e9cution de la macro \u00e0 un bouton de commande. Cette seconde solution pr\u00e9sente l&#8217;avantage d&#8217;\u00eatre plus professionnelle et facilit\u00e9 l&#8217;usage de votre feuille de travail par un autre utilisateur. C&#8217;est cette seconde solution que nous allons aborder dans le pr\u00e9sent article.<\/p>\n<p style=\"text-align: justify;\">Pour ce faire, acc\u00e9der sur le menu <a title=\"Si le menu D\u00e9veloppeur ne figure pas dans le bandeau d'Excel, cliquer ici...\" href=\"http:\/\/www.auditsi.eu\/?p=4039\">D\u00e9veloppeur<\/a> :<\/p>\n<div id=\"attachment_5902\" style=\"width: 817px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-menu-d\u00e9veloppeur.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-5902\" class=\" wp-image-5902\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-menu-d\u00e9veloppeur.png\" alt=\"Menu D\u00e9veloppeur d'Excel 2010\" width=\"807\" height=\"86\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-menu-d\u00e9veloppeur.png 1051w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-menu-d\u00e9veloppeur-300x32.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-menu-d\u00e9veloppeur-1024x109.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-menu-d\u00e9veloppeur-730x78.png 730w\" sizes=\"auto, (max-width: 807px) 100vw, 807px\" \/><\/a><p id=\"caption-attachment-5902\" class=\"wp-caption-text\">Menu D\u00e9veloppeur d&#8217;Excel 2010<\/p><\/div>\n<p style=\"text-align: justify;\">Puis cliquer sur &#8220;Ins\u00e9rer&#8221; et s\u00e9lectionner l&#8217;ic\u00f4ne &#8220;bouton&#8221; dans la section &#8220;Contr\u00f4les de formulaire&#8221; :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-ins\u00e9rer-un-contr\u00f4le-de-formulaire.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5906\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-ins\u00e9rer-un-contr\u00f4le-de-formulaire.png\" alt=\"Ins\u00e9rer un contr\u00f4le de formulaire (Excel)\" width=\"192\" height=\"188\" \/><\/a>Ceci fait, la fl\u00e8che de la souris se transforme en une croix nous invitant \u00e0 dessiner la forme du bouton :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-dessin-du-bouton.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5908\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-dessin-du-bouton.png\" alt=\"Dessiner le bouton de commande (Excel)\" width=\"535\" height=\"393\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-dessin-du-bouton.png 535w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-dessin-du-bouton-300x220.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Une fois la souris rel\u00e2ch\u00e9e, une fen\u00eatre appara\u00eet pour demander \u00e0 quelle macro le bouton nouvellement cr\u00e9\u00e9 doit \u00eatre rattach\u00e9 :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-affectation-macro-bouton.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5909\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-affectation-macro-bouton.png\" alt=\"Affecter une macro \u00e0 un bouton (Excel)\" width=\"476\" height=\"369\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-affectation-macro-bouton.png 476w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-affectation-macro-bouton-300x233.png 300w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Cliquer sur la macro souhait\u00e9e (ici &#8220;Traite_OngletsNonVides&#8221;) puis valider en cliquant sur le bouton &#8220;Ok&#8221;. Ceci fait, le bouton tr\u00f4ne maintenant fi\u00e8rement sur notre feuille de calcul :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5910\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton.png\" alt=\"Bouton de commande Excel\" width=\"523\" height=\"371\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton.png 523w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton-300x213.png 300w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Il ne reste plus qu&#8217;\u00e0 d\u00e9placer le bouton sur la feuille, le redimensionner et lui affecter un texte en rapport avec la nature de la t\u00e2che trait\u00e9e par la macro VBA ; pour ce faire, un clic droit fera appara\u00eetre le menu contextuel suivant :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-modifier-texte-bouton.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5911\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-modifier-texte-bouton.png\" alt=\"Bouton de commande Excel\" width=\"384\" height=\"323\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-modifier-texte-bouton.png 384w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-modifier-texte-bouton-300x252.png 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/a>Et voici notre bouton, une fois le texte modifi\u00e9 et mis en forme :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton-termin\u00e9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5912\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton-termin\u00e9.png\" alt=\"Bouton de commande termin\u00e9 (Excel)\" width=\"522\" height=\"381\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton-termin\u00e9.png 522w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-bouton-termin\u00e9-300x219.png 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\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&#8217;enregistreur 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%20affecter%20une%20macro%20%C3%A0%20un%20bouton%20de%20commande\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Pour d\u00e9clencher manuellement l&#8217;ex\u00e9cution une macro VBA, il y a deux solutions. La premi\u00e8re consiste \u00e0 la s\u00e9lectionner dans la liste des macros puis \u00e0 l&#8217;ex\u00e9cuter. La deuxi\u00e8me consiste \u00e0 affecter l&#8217;ex\u00e9cution de la macro \u00e0 un bouton de commande. Cette seconde solution pr\u00e9sente l&#8217;avantage d&#8217;\u00eatre plus professionnelle et facilit\u00e9 l&#8217;usage de votre feuille de &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=5901\" class=\"more-link\">Continue reading &lsquo;Excel &#038; VBA : affecter une macro \u00e0 un bouton de commande&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%20affecter%20une%20macro%20%C3%A0%20un%20bouton%20de%20commande\";<\/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":[1571,1633,217,1216,1641],"class_list":["post-5901","post","type-post","status-publish","format-standard","hentry","category-excel","category-programmer-en-vba","category-vba","tag-bouton-de-commande","tag-excel","tag-macro-commande","tag-menu-developpeur","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\/5901","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=5901"}],"version-history":[{"count":7,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/5901\/revisions"}],"predecessor-version":[{"id":5917,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/5901\/revisions\/5917"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}