{"id":178445,"date":"2022-10-27T13:33:50","date_gmt":"2022-10-27T13:33:50","guid":{"rendered":"https:\/\/datascientest.com\/?p=178445"},"modified":"2024-02-13T16:22:46","modified_gmt":"2024-02-13T16:22:46","slug":"realiser-une-macro-sur-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/realiser-une-macro-sur-excel","title":{"rendered":"Macro Excel : de la cr\u00e9ation \u00e0 l&rsquo;utilisation"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178445\" class=\"elementor elementor-178445\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5fab7be e-flex e-con-boxed e-con\" data-id=\"5fab7be\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d2044b2 elementor-widget elementor-widget-heading\" data-id=\"d2044b2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Tous les utilisateurs fr\u00e9quents d\u2019Excel ont eu \u00e0 r\u00e9aliser des t\u00e2ches r\u00e9p\u00e9titives. Que ce soit calculer des sommes, mettre en forme des donn\u00e9es ou encore s\u00e9lectionner des cellules, r\u00e9aliser ses t\u00e2ches \u00e0 la main peut vite devenir chronophage. Le meilleur moyen pour acc\u00e9l\u00e9rer ces processus est aujourd\u2019hui les macros.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6201ecc e-flex e-con-boxed e-con\" data-id=\"6201ecc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-876a4db elementor-widget elementor-widget-text-editor\" data-id=\"876a4db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Pour d\u00e9finir rapidement une macro, c\u2019est une <strong>s\u00e9quence d\u2019instructions qu\u2019ex\u00e9cute Microsoft Excel<\/strong> quand on lui demande de le faire.<\/p><p>Nous allons voir dans cet article les deux principaux moyens de cr\u00e9er une macro dans un classeur Excel :<\/p><ul><li>Avec l\u2019<strong>enregistreur Excel<\/strong><\/li><li>Avec le langage de programmation d\u00e9di\u00e9 de Microsoft Excel : <strong>Visual Basic Editor ou VBA<\/strong>.<\/li><\/ul><p>Mais avant cela, il est primordial de v\u00e9rifier que l\u2019onglet D\u00e9veloppeur est activ\u00e9 et pr\u00e9sent dans le Ruban d\u2019Excel. Pour cela il suffit d\u2019aller dans le menu <strong>Fichier \/ Options \/ Personnaliser<\/strong> le ruban puis cochez l\u2019onglet <strong>D\u00e9veloppeur<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bc1e8d4 elementor-widget elementor-widget-image\" data-id=\"bc1e8d4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"941\" height=\"682\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel1.png\" class=\"attachment-full size-full wp-image-178448\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel1.png 941w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel1-300x217.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel1-768x557.png 768w\" sizes=\"(max-width: 941px) 100vw, 941px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-05cee01 e-flex e-con-boxed e-con\" data-id=\"05cee01\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4494fcf elementor-widget elementor-widget-heading\" data-id=\"4494fcf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Cr\u00e9er une macro avec l\u2019enregistreur Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f81787 elementor-widget elementor-widget-text-editor\" data-id=\"4f81787\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Vous pouvez d\u00e9sormais commencer \u00e0 enregistrer une macro \u00e0 l\u2019aide de l\u2019onglet du m\u00eame nom.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-647ebdd elementor-widget elementor-widget-image\" data-id=\"647ebdd\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"693\" height=\"197\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel2.png\" class=\"attachment-full size-full wp-image-178449\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel2.png 693w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel2-300x85.png 300w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b5db1b elementor-widget elementor-widget-text-editor\" data-id=\"3b5db1b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Il vous sera demand\u00e9 de donner un nom \u00e0 votre macro et de choisir un raccourci si vous le souhaitez. Attention \u00e0 ce que votre raccourci n\u2019existe pas d\u00e9j\u00e0 dans la grande banque de raccourci d\u2019Excel. Il vous sera possible de lui donner une rapide <strong>description<\/strong>. Vous pouvez \u00e9galement choisir d\u2019enregistrer votre macro dans un de ses trois dossiers : ce classeur, un nouveau classeur, votre classeur de macros personnelles. Ce choix d\u00e9pendra de votre utilisation de la macro. Si vous souhaitez la r\u00e9utiliser dans d\u2019autres classeurs Excel, enregistrez-la dans votre classeur de macros personnelles pour un acc\u00e8s plus rapide.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c5ba08 elementor-widget elementor-widget-text-editor\" data-id=\"3c5ba08\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Si vous d\u00e9sirez <strong>apprendre un peu plus sur Microsoft Excel<\/strong>, d\u00e9couvrez la formation propos\u00e9e par DataScientest.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9153791 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9153791\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former en analyse de donn\u00e9es<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Tous les utilisateurs fr\u00e9quents d\u2019Excel ont eu \u00e0 r\u00e9aliser des t\u00e2ches r\u00e9p\u00e9titives. Que ce soit calculer des sommes, mettre en forme des donn\u00e9es ou encore s\u00e9lectionner des cellules, r\u00e9aliser ses t\u00e2ches \u00e0 la main peut vite devenir chronophage. Le meilleur moyen pour acc\u00e9l\u00e9rer ces processus est aujourd\u2019hui les macros. Pour d\u00e9finir rapidement une macro, c\u2019est [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":178447,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Macro Excel : de la cr\u00e9ation \u00e0 l&#039;utilisation<\/title>\n<meta name=\"description\" content=\"Une macro est une s\u00e9quence d\u2019instructions qu\u2019ex\u00e9cute Microsoft Excel quand on lui demande de le faire. Nous allons voir dans cet article les deux principaux moyens d&#039;en cr\u00e9er une.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/realiser-une-macro-sur-excel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Macro Excel : de la cr\u00e9ation \u00e0 l&#039;utilisation\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/realiser-une-macro-sur-excel\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-27T13:33:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-13T16:22:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/realiser-une-macro-sur-excel\",\"url\":\"https:\/\/datascientest.com\/realiser-une-macro-sur-excel\",\"name\":\"Macro Excel : de la cr\u00e9ation \u00e0 l'utilisation\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-10-27T13:33:50+00:00\",\"dateModified\":\"2024-02-13T16:22:46+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Une macro est une s\u00e9quence d\u2019instructions qu\u2019ex\u00e9cute Microsoft Excel quand on lui demande de le faire. Nous allons voir dans cet article les deux principaux moyens d'en cr\u00e9er une.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/realiser-une-macro-sur-excel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Macro Excel : de la cr\u00e9ation \u00e0 l'utilisation","description":"Une macro est une s\u00e9quence d\u2019instructions qu\u2019ex\u00e9cute Microsoft Excel quand on lui demande de le faire. Nous allons voir dans cet article les deux principaux moyens d'en cr\u00e9er une.","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:\/\/datascientest.com\/realiser-une-macro-sur-excel","og_locale":"fr_FR","og_type":"article","og_title":"Macro Excel : de la cr\u00e9ation \u00e0 l'utilisation","og_url":"https:\/\/datascientest.com\/realiser-une-macro-sur-excel","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-10-27T13:33:50+00:00","article_modified_time":"2024-02-13T16:22:46+00:00","og_image":[{"width":900,"height":450,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/macro-excel.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/realiser-une-macro-sur-excel","url":"https:\/\/datascientest.com\/realiser-une-macro-sur-excel","name":"Macro Excel : de la cr\u00e9ation \u00e0 l'utilisation","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-10-27T13:33:50+00:00","dateModified":"2024-02-13T16:22:46+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Une macro est une s\u00e9quence d\u2019instructions qu\u2019ex\u00e9cute Microsoft Excel quand on lui demande de le faire. Nous allons voir dans cet article les deux principaux moyens d'en cr\u00e9er une.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/realiser-une-macro-sur-excel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/178445"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=178445"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/178445\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/178447"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=178445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=178445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=178445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}