{"id":5875,"date":"2015-02-15T10:17:38","date_gmt":"2015-02-15T09:17:38","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=5875"},"modified":"2015-02-15T10:22:40","modified_gmt":"2015-02-15T09:22:40","slug":"excel-enregistrer-un-classeur-contenant-une-macro-vba","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=5875","title":{"rendered":"EXCEL : enregistrer un classeur contenant une macro VBA"},"content":{"rendered":"<p style=\"text-align: justify;\">Par d\u00e9faut, depuis la version 2007 d&#8217;Excel, un classeur est dot\u00e9 de l&#8217;extension *.xlsx. Un tel classeur ne peut comprendre de macro VBA. D&#8217;ailleurs, si l&#8217;on enregistre un classeur comprenant une macro VBA avec cette extension, la macro sera irr\u00e9m\u00e9diablement perdue ; un message alerte l&#8217;utilisateur sur ce risque en cas d&#8217;erreur.<\/p>\n<p style=\"text-align: justify;\">Pour enregistrer un classeur Excel avec ses macros VBA, il suffit de l&#8217;enregistrer au format *.xlsm.<\/p>\n<p style=\"text-align: justify;\">Pour ce faire, aller dans le menu Fichier, puis cliquer sur &#8220;Enregistrer sous&#8221;.<br \/>\n<a style=\"text-align: justify;\" href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-Enregistrer-sous.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5878\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XL-Enregistrer-sous.png\" alt=\"Excel : Menu Fichier, Enregistrer sous...\" width=\"147\" height=\"201\" \/><\/a>La fen\u00eatre &#8220;Enregistrer sous&#8221; s&#8217;ouvre :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XLSM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5879\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XLSM.png\" alt=\"Excel : classeur avec macro VBA (extension *.xlsm)\" width=\"441\" height=\"483\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XLSM.png 441w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2015\/02\/XLSM-274x300.png 274w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/a>Apr\u00e8s avoir saisi le nom \u00e0 donner au classeur, choisir le type &#8220;Classeur Excel (prenant en charge les macros)&#8221; puis valider. Le classeur est enregistr\u00e9 avec ses macros ; son extension est maintenant *.xlsm.<\/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><\/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%3A%20enregistrer%20un%20classeur%20contenant%20une%20macro%20VBA\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Par d\u00e9faut, depuis la version 2007 d&#8217;Excel, un classeur est dot\u00e9 de l&#8217;extension *.xlsx. Un tel classeur ne peut comprendre de macro VBA. D&#8217;ailleurs, si l&#8217;on enregistre un classeur comprenant une macro VBA avec cette extension, la macro sera irr\u00e9m\u00e9diablement perdue ; un message alerte l&#8217;utilisateur sur ce risque en cas d&#8217;erreur. Pour enregistrer un &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=5875\" class=\"more-link\">Continue reading &lsquo;EXCEL : enregistrer un classeur contenant une macro VBA&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%3A%20enregistrer%20un%20classeur%20contenant%20une%20macro%20VBA\";<\/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":[227,1570,1633,217,1641],"class_list":["post-5875","post","type-post","status-publish","format-standard","hentry","category-excel","category-programmer-en-vba","category-vba","tag-xlsm","tag-enregistrer-sous","tag-excel","tag-macro-commande","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\/5875","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=5875"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/5875\/revisions"}],"predecessor-version":[{"id":5883,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/5875\/revisions\/5883"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}