{"id":1490,"date":"2023-11-21T17:33:52","date_gmt":"2023-11-21T17:33:52","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/"},"modified":"2023-12-10T06:01:36","modified_gmt":"2023-12-10T06:01:36","slug":"makro-kaydet","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/","title":{"rendered":"Excel&#39;de makro nas\u0131l kaydedilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1825962140\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p class=\"wp-block-heading\"><strong>ANAHTAR NOKTALARI<\/strong><\/p><ul><li> Makro kaydetmek, Excel&#8217;de ger\u00e7ekle\u015ftirdi\u011finiz eylemleri kaydetmek anlam\u0131na gelir.<\/li><li> Makro kaydetmek i\u00e7in makro kaydediciyi kullanman\u0131z gerekir.<\/li><li> Makro kaydedici, siz aktiviteyi ger\u00e7ekle\u015ftirirken arkadaki kodu \u00fcretir.<\/li><li> Excel&#8217;de makro kaydederken duraklatamazs\u0131n\u0131z.<\/li><li> Makro kaydedici m\u00fckemmel kod olu\u015fturmaz; bu nedenle kay\u0131ttan sonra kodunuzu temizledi\u011finizden emin olun.<\/li><\/ul><p> Bu k\u0131lavuz, makro kaydetmenin t\u00fcm y\u00f6nlerini \u00f6\u011frenmenize yard\u0131mc\u0131 olacakt\u0131r. Ayr\u0131ca kodu kaydettikten sonra nas\u0131l temizleyece\u011finizi de \u00f6\u011freneceksiniz.<\/p><p> \u00d6yleyse ba\u015flayal\u0131m.<\/p><h2 class=\"wp-block-heading\"> Makro kaydedici nedir?<\/h2><p> Excel Makro Kaydedici, Excel&#8217;de ger\u00e7ekle\u015ftirdi\u011finiz <strong>eylemleri (t\u00fcm\u00fcn\u00fc de\u011fil) kaydedebilen<\/strong> ve bunun i\u00e7in <strong>kod \u00fcreten<\/strong> bir ara\u00e7t\u0131r. Belirli bir g\u00f6revi bir kez yapt\u0131\u011f\u0131n\u0131zda bunun i\u00e7in bir makro olu\u015fturulur ve bir dahaki sefere o g\u00f6revi manuel olarak yapmak yerine o kodu \u00e7al\u0131\u015ft\u0131rman\u0131z gerekir.<\/p><p> Bir video kamera d\u00fc\u015f\u00fcn\u00fcn, o da onun gibi \u00e7al\u0131\u015f\u0131yor ve yapt\u0131\u011f\u0131n\u0131z aktiviteye g\u00f6re kod \u00fcretiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49640\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"479\" height=\"301\"><\/figure><\/div><p class=\"content-box-red\"> Bir makro kaydedicinin kod sa\u011flayamad\u0131\u011f\u0131 zamanlar\u0131n olabilece\u011fini anlamal\u0131s\u0131n\u0131z. Ancak, bilmiyorsan\u0131z kodu \u00f6\u011frenmenin yine de harika bir yolu.<\/p><p> Makro kaydedici d\u00fc\u011fmesini <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">geli\u015ftirici sekmesinde<\/a> bulabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49433\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-bouton-enregistreur-macro.png\" sizes=\"auto, \" srcset=\"\" alt=\"makro kaydedici d\u00fc\u011fmesi\" width=\"298\" height=\"119\"><\/figure><\/div><p class=\"content-box-grey\"> <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">Excel&#8217;de programlama i\u00e7in VBA&#8217;y\u0131<\/a> kullanmak <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">, Excel&#8217;deki ileri d\u00fczey becerilerden<\/a> biridir ve VBA&#8217;ya ba\u015flamak i\u00e7in makro kaydetme konusunda uzman olman\u0131z gerekir.<\/p><h2 class=\"wp-block-heading\"> Makro kaydetmeden \u00f6nce planlama<\/h2><p> Bir video kaydetmek istiyorsan\u0131z \u00f6nceden bir senaryo olu\u015fturmak, uygun \u0131\u015f\u0131klara sahip olmak vb. gibi k\u00fc\u00e7\u00fck bir planlama yapman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49432\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-a-propos-de-lenregistreur-de-macros.png\" sizes=\"auto, \" srcset=\"\" alt=\"makro kaydedici hakk\u0131nda\" width=\"672\" height=\"150\"><\/figure><\/div><p> Benzer \u015fekilde, bir makroyu kaydetmek de biraz planlama gerektirir.<\/p><p> Mesele \u015fu ki, kaydedilen makroyu tekrar kullan\u0131rken \u00e7al\u0131\u015ft\u0131rmak istemedi\u011finiz aktivitenin kodunu almak istemezsiniz.<\/p><p> Bunu yapman\u0131n en iyi yolu, tamamlaman\u0131z gereken ad\u0131mlar\u0131 yazmak ve kay\u0131t s\u0131ras\u0131nda bunlara ba\u011fl\u0131 kalmakt\u0131r.<\/p><p> Burada se\u00e7ilen h\u00fccreye a\u015fa\u011f\u0131daki format\u0131 uygulayabilecek bir makro kaydedece\u011fiz:<\/p><ul><li> Yaz\u0131 tipi rengi: k\u0131rm\u0131z\u0131<\/li><li> Yaz\u0131 tipi boyutu: 12<\/li><li> Yaz\u0131 tipi stili: Verdena<\/li><li> Yaz\u0131 tipi metni: Kal\u0131n<\/li><\/ul><p> Dedi\u011fim gibi planlama \u00e7ok \u00f6nemli ve bu makroyu kaydetmeden \u00f6nce dikkat etmemiz gereken bir \u015fey var, o da kayda ba\u015flamadan \u00f6nce hedef h\u00fccreyi se\u00e7mek.<\/p><p> Dedi\u011fim gibi planlama \u00e7ok \u00f6nemli ve bu makroyu kaydetmeden \u00f6nce dikkat etmemiz gereken bir \u015fey var, o da kayda ba\u015flamadan \u00f6nce hedef h\u00fccreyi se\u00e7mek.<\/p><p> Sebebi ise makroyu kaydederken bir h\u00fccreyi se\u00e7ersek o se\u00e7imi de kaydedecektir.<\/p><p> Yani bu makroyu tekrar \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, t\u00fcm bi\u00e7imlendirmeyi uygulamak i\u00e7in s\u00f6z konusu h\u00fccreyi se\u00e7ecektir. Ancak istedi\u011fimiz, aktif olan (se\u00e7ili olan) h\u00fccreye format uygulamakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> Makro Kaydediciyi Kullanarak Makro Kaydetme Ad\u0131mlar\u0131<\/h2><p> <strong>Excel&#8217;de bir MAKRO KAYDETMEK i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/strong><\/p><ol><li> \u00d6ncelikle A4 h\u00fccresini se\u00e7in (bu h\u00fccre formatlamay\u0131 uygulayaca\u011f\u0131m\u0131z ve makromuzu kaydedece\u011fimiz h\u00fccredir). <br><img loading=\"lazy\" decoding=\"async\" title=\"3-Excel'de bir makroyu kaydetme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-enregistrer-une-macro-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"record-a-macro-in-excel\" width=\"294\" height=\"206\"><\/li><li> Bundan sonra, &#8220;Geli\u015ftirici sekmesine&#8221; gidin ve &#8220;KAYDET&#8221; d\u00fc\u011fmesine basmadan \u00f6nce ilgili referans\u0131 etkinle\u015ftirin (bununla ilgili daha fazla bilgiyi birka\u00e7 dakika i\u00e7inde \u00f6\u011frenece\u011fiz). <br><img decoding=\"async\" title=\"4-a\u00e7\u0131k-g\u00f6receli referans\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-activer-la-reference-relative.png\" sizes=\"\" srcset=\"\" alt=\"turn-on-the-relative-reference\"><\/li><li> Kay\u0131t d\u00fc\u011fmesine bas\u0131n.<\/li><li> Ve \u00fczerine t\u0131klad\u0131\u011f\u0131n\u0131z anda, kaydedece\u011finiz makroyla ilgili baz\u0131 ayr\u0131nt\u0131lar\u0131 dolduraca\u011f\u0131n\u0131z bir ileti\u015fim kutusuyla kar\u015f\u0131la\u015facaks\u0131n\u0131z (evet, onu doldurmam\u0131z gerekiyor). <br><img loading=\"lazy\" decoding=\"async\" title=\"Makroyla ilgili baz\u0131 ayr\u0131nt\u0131lar\u0131 doldurmak i\u00e7in 6 ileti\u015fim kutusu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-boite-de-dialogue-pour-remplir-certains-des-details-sur-la-macro.png\" sizes=\"auto, \" srcset=\"\" alt=\"dialog-box-to-fill-some-of-the-details-about-the-macro\" width=\"408\" height=\"328\"><ul><li> Makro ad\u0131: \u201cHighlightCell\u201d.<\/li><li> K\u0131sayol tu\u015fu: Control+Shift+H klavye k\u0131sayolunu ayarlamak i\u00e7in Shift+H tu\u015flar\u0131na bas\u0131n.<\/li><li> Makroyu \u015furada saklay\u0131n: Ki\u015fisel Makro Ciltleyici&#8217;yi se\u00e7in.<\/li><li> A\u00e7\u0131klama: Bu makro k\u0131rm\u0131z\u0131 renk, yaz\u0131 tipi boyutu 12, Verdana yaz\u0131 tipi stili uygular ve yaz\u0131 tipini kal\u0131n yapar.<\/li><\/ul><\/li><li> Son olarak Tamam&#8217;a t\u0131klay\u0131n.<\/li><li> Bu noktada, Excel her \u015feyi kaydetmek i\u00e7in y\u0131ld\u0131z verir (durum \u00e7ubu\u011funda &#8220;Bir makro kaydediyor, kayd\u0131 durdurmak i\u00e7in t\u0131klay\u0131n&#8221; yazan simgeyi g\u00f6rebilirsiniz). <br><img loading=\"lazy\" decoding=\"async\" title=\"7-a-makro-kaydediliyor\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-une-macro-est-en-train-denregistrer.png\" sizes=\"auto, \" srcset=\"\" alt=\"a-macro-is-currently-recording\" width=\"422\" height=\"64\"><\/li><li> \u015eimdi karar verdi\u011fimiz d\u00f6rt format\u0131 uygulay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-d\u00f6rt-bi\u00e7imlendirmeyi-uygulay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-appliquer-les-quatre-formatages.png\" sizes=\"auto, \" srcset=\"\" alt=\"apply-all-the-four-formattings\" width=\"266\" height=\"123\"><ul><li> Yaz\u0131 tipi rengi: k\u0131rm\u0131z\u0131<\/li><li> Yaz\u0131 tipi boyutu: 12<\/li><li> Yaz\u0131 tipi stili: Verdena<\/li><li> Yaz\u0131 tipi metni: Kal\u0131n<\/li><\/ul><\/li><li> Bunu yapt\u0131ktan sonra geli\u015ftirici sekmesine geri d\u00f6n\u00fcn ve &#8220;Kayd\u0131 durdur&#8221;a t\u0131klay\u0131n veya durum \u00e7ubu\u011funda &#8220;Kayd\u0131 durdurmak i\u00e7in buraya t\u0131klay\u0131n&#8221; yazan yerden de kayd\u0131 durdurabilirsiniz. kay\u0131t&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"9 ad\u0131mda kay\u0131t\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-arreter-lenregistrement.png\" sizes=\"auto, \" srcset=\"\" alt=\"stop-recording\" width=\"261\" height=\"115\"><\/li><\/ol><p> <strong>Tebrikler!<\/strong> Bunu yapt\u0131n\u0131z ve bu noktada \u00e7al\u0131\u015fma kitab\u0131n\u0131za kaydedilmi\u015f bir makronuz var, ancak \u015fimdi bir sonraki ad\u0131m onu anlamakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> Makro Kaydedici Kodu Nas\u0131l Olu\u015fturur?<\/h2><p> Makro kaydedici, siz aktiviteleri ger\u00e7ekle\u015ftirirken arka tarafta sizin i\u00e7in bir kod olu\u015fturur.<\/p><p> Bunu anlamak i\u00e7in \u00f6ncelikle kodu g\u00f6rmeniz gerekir. Bunu yapmak i\u00e7in <strong><a href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\">Visual Basic d\u00fczenleyicisini<\/a><\/strong> a\u00e7\u0131n, Geli\u015ftirici sekmesine \u279c Visual Basic D\u00fczenleyici&#8217;ye gidin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49441\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-ouvrir-lediteur-de-base-visuel.png\" sizes=\"auto, \" srcset=\"\" alt=\"a\u00e7\u0131k-g\u00f6rsel-temel-d\u00fczenleyici\" width=\"313\" height=\"131\"><\/figure><\/div><p> Daha sonra kodunuzun sakland\u0131\u011f\u0131 mod\u00fcl1&#8217;i a\u00e7\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49442\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-ouvrir-le-module1.png\" sizes=\"auto, \" srcset=\"\" alt=\"a\u00e7\u0131k mod\u00fcl1\" width=\"1190\" height=\"854\"><\/figure><\/div><p> Kod penceresinde makro kaydedici taraf\u0131ndan olu\u015fturulan kodun tamam\u0131n\u0131 girdi\u011finiz t\u00fcm ayr\u0131nt\u0131larla birlikte g\u00f6rebilirsiniz.<\/p><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi makro ad\u0131, k\u0131sayol tu\u015fu ve a\u00e7\u0131klamas\u0131 kodun \u00f6n\u00fcnde yer al\u0131yor.<\/p><p> \u015eimdi kodu anlayal\u0131m <em>(daha \u00f6nce de s\u00f6yledi\u011fim gibi, makro kaydedici m\u00fckemmel kod olu\u015fturmaz, dolay\u0131s\u0131yla her seferinde onu temizlemeniz gerekir, bunu bir sonraki b\u00f6l\u00fcmde \u00f6\u011frenece\u011fiz).<\/em><\/p><p> D\u00f6rt etkinli\u011fin tamam\u0131n\u0131 tamamlad\u0131n\u0131z ve makro kaydedici d\u00f6rt b\u00f6l\u00fcml\u00fc kodu olu\u015fturdu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49443\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-macro-enregistreur-a-genere-le-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"makro kaydedici taraf\u0131ndan olu\u015fturulan kod\" width=\"459\" height=\"562\"><\/figure><\/div><ol><li> \u0130lk k\u0131s\u0131mda kod se\u00e7ilen h\u00fccrenin yaz\u0131 renginin k\u0131rm\u0131z\u0131 olmas\u0131 gerekti\u011fini s\u00f6yl\u00fcyor ve bunun i\u00e7in say\u0131sal bir de\u011fer kullan\u0131yordu.<\/li><li> Kodun ikinci k\u0131sm\u0131 se\u00e7ilen h\u00fccrelerin yaz\u0131 tipi boyutunun &#8220;12&#8221; olmas\u0131 gerekti\u011fini belirtir.<\/li><li> \u00dc\u00e7\u00fcnc\u00fc b\u00f6l\u00fcmde ise yaz\u0131 stilinin &#8220;Verdana&#8221; olmas\u0131 gerekti\u011fi yaz\u0131yor.<\/li><li> Son olarak d\u00f6rd\u00fcnc\u00fc b\u00f6l\u00fcmde se\u00e7ilen h\u00fccrenin yaz\u0131 tipinin kal\u0131n olmas\u0131 gerekti\u011fi yaz\u0131yor.<\/li><\/ol><h2 class=\"wp-block-heading\"> Kaydedilen makroyu temizle<\/h2><p> Bu noktada ilk makronuzu kaydettiniz ve bu kodun nas\u0131l olu\u015fturuldu\u011funu biliyorsunuz. Ancak mod\u00fcldeki kodu temizlemeniz gerekir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub HighlightCell() ' 'HighlightCell Macro 'This macro applies a red color, font size 12, 'font style Verdana, and makes the font bold ' 'Keyboard Shortcut: Ctrl+Shift+H ' With Selection.Font .Color = -16776961 .TintAndShade = 0 End With With Selection.Font .Name = \"Calibri\" .Size = 12 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNo .Color = -16776961 .TintAndShade = 0 .ThemeFont = xlThemeFontMinor End With With Selection.Font .Name = \"Verdana\" .Size = 12 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .Color = -16776961 .TintAndShade = 0 .ThemeFont = xlThemeFontNone End With Selection.Font.Bold = True End Sub<\/code><\/pre><p> Yak\u0131ndan bakarsan\u0131z, bu onun yapabilece\u011fi aktivitelerden \u00e7ok daha uzun bir s\u00fcre. Bu kodda gerekli olmayan bir\u00e7ok \u00f6zellik bulunmaktad\u0131r.<\/p><p> Sadece bu kodla de\u011fil, her makro kaydetti\u011finizde onu temizlemeniz gerekir.<\/p><p> Ancak bu kodu temizlemeye ba\u015flamadan \u00f6nce, mod\u00fcl\u00fcn\u00fczde kod bulunmas\u0131 gereken, yapt\u0131\u011f\u0131n\u0131z d\u00f6rt etkinli\u011fi hat\u0131rlaman\u0131z gerekir:<\/p><ul><li> Yaz\u0131 tipi rengi: k\u0131rm\u0131z\u0131<\/li><li> Yaz\u0131 tipi boyutu: 12<\/li><li> Yaz\u0131 tipi stili: Verdena<\/li><li> Yaz\u0131 tipi metni: Kal\u0131n<\/li><\/ul><p> Bu d\u00f6rt aktiviteyi ger\u00e7ekle\u015ftiren kod sat\u0131rlar\u0131n\u0131 tan\u0131mlayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49444\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-identifier-les-lignes-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"kod sat\u0131rlar\u0131n\u0131 tan\u0131mla\" width=\"402\" height=\"492\"><\/figure><\/div><p> Art\u0131k ger\u00e7ekle\u015ftirdi\u011finiz etkinlikleri ger\u00e7ekle\u015ftiren kod sat\u0131rlar\u0131n\u0131 belirlediniz ve elimizde bu d\u00f6rt b\u00f6l\u00fcml\u00fc kod da var.<\/p><p> Kodu temizlemenin ve istenmeyen t\u00fcm sat\u0131rlar\u0131 kald\u0131rman\u0131n zaman\u0131 geldi. A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip et.<\/p><ul><li> \u0130LK k\u0131s\u0131mda KIRMIZI yaz\u0131 tipi rengini uygulayan sat\u0131r koduna ihtiyac\u0131n\u0131z vard\u0131r, dolay\u0131s\u0131yla &#8220;TintAndShade&#8221; \u00f6zelli\u011fi buna gerek duymaz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49445\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-14-lignes-qui-applique-la-couleur-de-police-rouge.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u0131rm\u0131z\u0131 yaz\u0131 tipi rengini uygulayan sat\u0131r kodu\" width=\"356\" height=\"122\"><\/figure><\/div><ul><li> \u015eimdi \u0130K\u0130NC\u0130 b\u00f6l\u00fcmde di\u011fer t\u00fcm \u00f6zelliklere de\u011fil, yaz\u0131 tipi boyutuna ihtiyac\u0131m\u0131z var, bu y\u00fczden bunlar\u0131 kald\u0131r\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49446\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-la-taille-de-la-police.png\" sizes=\"auto, \" srcset=\"\" alt=\"yaz\u0131 Boyutu\" width=\"320\" height=\"298\"><\/figure><\/div><ul><li> Bundan sonra \u00dc\u00c7\u00dcNC\u00dc b\u00f6l\u00fcmde font name \u00f6zelli\u011fine sahip olmam\u0131z gerekiyor, bu nedenle di\u011fer t\u00fcm \u00f6zellikleri kald\u0131r\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49447\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-propriete-de-nom-de-police.png\" sizes=\"auto, \" srcset=\"\" alt=\"yaz\u0131 tipi ad\u0131 \u00f6zelli\u011fi\" width=\"332\" height=\"287\"><\/figure><\/div><ul><li> D\u00d6RD\u00dcNC\u00dc b\u00f6l\u00fcmde, yaln\u0131zca yaz\u0131 tipini kal\u0131n yapacak tek bir kod sat\u0131r\u0131n\u0131z var.<\/li><\/ul><p> Bu noktada kod \u015fu \u015fekilde g\u00f6r\u00fcn\u00fcr; bu, makro kaydedici taraf\u0131ndan olu\u015fturulan koddan \u00e7ok daha d\u00fc\u015f\u00fckt\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49448\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-mettre-la-police-en-gras.png\" sizes=\"auto, \" srcset=\"\" alt=\"yaz\u0131 tipini kal\u0131n yap\" width=\"288\" height=\"312\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub HighlightCell() ' 'HighlightCell Macro 'This macro applies a red color, font size 12, 'font style Verdana, and makes the font bold ' 'Keyboard Shortcut: Ctrl+Shift+H ' With Selection.Font .Color = -16776961 End With With Selection.Font .Size = 12 End With With Selection.Font .Name = \"Verdana\" End With Selection.Font.Bold = True End Sub<\/code><\/pre><p> Ama yine de daha fazlas\u0131n\u0131 yapabilirsiniz.<\/p><p> Koda yak\u0131ndan bakarsan\u0131z, &#8220;With Selection.Font&#8221; ifadesini d\u00f6rt kez kulland\u0131\u011f\u0131n\u0131 g\u00f6r\u00fcrs\u00fcn\u00fcz, ancak d\u00f6rt \u00f6zelli\u011fin t\u00fcm\u00fc i\u00e7in ayn\u0131 nesneye at\u0131fta bulundu\u011funuz i\u00e7in onu bir kez kullanabilirsiniz.<\/p><p> Yani son kod \u015f\u00f6yle olacakt\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49449\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-code-final.png\" sizes=\"auto, \" srcset=\"\" alt=\"son kod\" width=\"252\" height=\"172\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub HighlightCell() ' 'HighlightCell Macro 'This macro applies a red color, font size 12, 'font style Verdana, and makes the font bold ' 'Keyboard Shortcut: Ctrl+Shift+H ' With Selection.Font .Color = -16776961 .Name = \"Verdana\" .Size = 12 .Bold = True End With End Sub<\/code><\/pre><p> Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda kaydetti\u011finiz etkinliklerin ayn\u0131s\u0131n\u0131 ger\u00e7ekle\u015ftirecektir.<\/p><h3 class=\"wp-block-heading\"> Sen ne yapt\u0131n?<\/h3><p> Yeni kodda yaln\u0131zca ihtiyac\u0131n\u0131z olan etkinlikleri ger\u00e7ekle\u015ftiren kod sat\u0131rlar\u0131n\u0131z var.<\/p><p> Burada anla\u015f\u0131lmas\u0131 gereken nokta, her nesnenin her zaman \u00f6zellikleri oldu\u011fu ve makro kaydedici kay\u0131t yapt\u0131\u011f\u0131nda, siz bunlar\u0131 kullanmasan\u0131z bile t\u00fcm bu \u00f6zellikleri o nesneyle birlikte ekledi\u011fidir.<\/p><p> Bu y\u00fczden t\u00fcm bu \u00f6zellikleri koddan kald\u0131rman\u0131z gerekiyor.<\/p><p> Di\u011feri ise kodunuzda tek bir nesne kullansan\u0131z bile, farkl\u0131 aktiviteler yapt\u0131\u011f\u0131n\u0131zda makro kaydedici tekrar tekrar ona ba\u015fvuruyor ve bu y\u00fczden &#8220;Se\u00e7imli. Yaz\u0131 Tipi&#8221;ni bir kez kullan\u0131p t\u00fcm \u00f6zellikleri onun alt\u0131na eklediniz. .<\/p><p> Her durumda, makro kaydedici taraf\u0131ndan olu\u015fturulan herhangi bir kodu temizlemek i\u00e7in, ihtiyac\u0131n\u0131z olan etkinlikleri ger\u00e7ekle\u015ftiren ger\u00e7ek kod sat\u0131rlar\u0131n\u0131 tan\u0131mlaman\u0131z ve geri kalan\u0131n\u0131 kald\u0131rman\u0131z gerekir.<\/p><p> Kaydedilen makro kodunu temizlerken en iyi yol, koddaki hatalar\u0131 ad\u0131m ad\u0131m ay\u0131klamakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> <strong>Oku onu<\/strong><\/h3><ul><li> VBA edit\u00f6r\u00fcn\u00fc ve Excel penceresini yan yana a\u00e7\u0131n, ard\u0131ndan F8 tu\u015funa basarak kodu ad\u0131m ad\u0131m \u00e7al\u0131\u015ft\u0131r\u0131n.<\/li><li> Yan tarafta Excel penceresi a\u00e7\u0131k oldu\u011fundan, etkinli\u011fin hangi kod sat\u0131r\u0131nda y\u00fcr\u00fct\u00fcld\u00fc\u011f\u00fcn\u00fc g\u00f6rebilirsiniz.<\/li><li> \u0130htiyac\u0131n\u0131z olan kodu belirledikten sonra kodu silebilirsiniz ki bu gerekli de\u011fildir.<\/li><\/ul><h2 class=\"wp-block-heading\"> Bir makroyu adland\u0131r\u0131n<\/h2><p> Her makro kaydetti\u011finizde, o makroya bir ad vermeniz gerekir, ancak bir ad\u0131n uymas\u0131 gereken birka\u00e7 kural vard\u0131r:<\/p><ul><li> Bir makronun ad\u0131 en fazla 80 karakter uzunlu\u011funda olabilir.<\/li><li> Bo\u015fluk, noktalama i\u015fareti veya \u00f6zel karakter kullanamazs\u0131n\u0131z.<\/li><li> Bir harfle ba\u015flamal\u0131d\u0131r.<\/li><\/ul><p> Bu kurallar\u0131n d\u0131\u015f\u0131nda VBA taraf\u0131ndan isim olarak kullan\u0131lmas\u0131 yasak olan birka\u00e7 kelime daha bulunmaktad\u0131r.<\/p><p> \u00d6te yandan Macro1 veya Test1 gibi varsay\u0131lan adlar yerine anlaml\u0131 bir ad kullan\u0131lmas\u0131 \u00f6nemlidir.<\/p><p> Makro ad\u0131nda bo\u015fluk kullanamayaca\u011f\u0131n\u0131z i\u00e7in okunabilirli\u011fi art\u0131rmak i\u00e7in alt \u00e7izgi kullanabilir veya her kelimenin ilk harfini b\u00fcy\u00fck yazabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Kaydedilen makronun saklanmas\u0131<\/h2><p> Bir makroyu kaydetmeden \u00f6nce, onu nereye kaydetmek istedi\u011finizi belirtmeniz gerekir ve bunun i\u00e7in \u00fc\u00e7 se\u00e7ene\u011finiz vard\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49450\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-memorisation-de-la-macro-enregistree.png\" sizes=\"auto, \" srcset=\"\" alt=\"makro kayd\u0131n\u0131 saklama\" width=\"434\" height=\"171\"><\/figure><\/div><ul><li> <strong>Yeni \u00c7al\u0131\u015fma Kitab\u0131<\/strong> : Makronuzu yeni bir \u00e7al\u0131\u015fma kitab\u0131na kaydetmek istiyorsan\u0131z bu se\u00e7ene\u011fi belirleyebilirsiniz.<\/li><li> <strong>Bu \u00e7al\u0131\u015fma kitab\u0131<\/strong> : Bu se\u00e7ene\u011fi se\u00e7erek makroyu ge\u00e7erli \u00e7al\u0131\u015fma kitab\u0131na kaydedebilirsiniz.<\/li><li> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\">Ki\u015fisel Makro \u00c7al\u0131\u015fma Kitab\u0131<\/a><\/strong> : Bu se\u00e7enek ile t\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131ndaki makrolara ula\u015fabilirsiniz.<\/li><\/ul><h2 class=\"wp-block-heading\"> G\u00f6reli referans<\/h2><p> Yukar\u0131daki makroyu kaydederken &#8220;Kayd\u0131 Ba\u015flat&#8221; butonuna basmadan \u00f6nce &#8220;G\u00f6reli Referanslar\u0131 Kullan&#8221; se\u00e7ene\u011fini se\u00e7menizi s\u00f6ylemi\u015ftim.<\/p><p> Excel&#8217;de bir makro kaydetti\u011finizde Excel varsay\u0131lan olarak &#8220;Mutlak Referans&#8221;\u0131 kullan\u0131r. Ancak makroyu kaydetmeden \u00f6nce bunu de\u011fi\u015ftirebilirsiniz.<\/p><p> \u00d6nemli olan nokta, bir makronun kaydedilen etkinli\u011fi \u00e7al\u0131\u015fma sayfas\u0131n\u0131n herhangi bir yerinde y\u00fcr\u00fctmesini istiyorsan\u0131z g\u00f6receli referanslar\u0131 kullanman\u0131n \u00e7ok \u00f6nemli olmas\u0131d\u0131r.<\/p><p> \u0130ki referans modu aras\u0131ndaki fark\u0131 anlaman\u0131z\u0131 sa\u011flamak i\u00e7in etkinli\u011fi iki farkl\u0131 \u015fekilde kaydetmenizi istiyorum.<\/p><ul><li> \u00d6ncelikle A1 h\u00fccresini se\u00e7in ve bir makro kaydetmeye ba\u015flay\u0131n (\u201cG\u00f6receli referans kullan\u201d se\u00e7ene\u011fini etkinle\u015ftirmeden), ard\u0131ndan <strong>E5 h\u00fccresini se\u00e7in<\/strong> .<\/li><li> Makro kaydedici ile a\u015fa\u011f\u0131daki kodu alacaks\u0131n\u0131z:<\/li><\/ul><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AbsoluteReferenceMacro() Range(\"E5\").Select End Sub<\/code><\/pre><ul><li> Tekrar A1 h\u00fccresini se\u00e7in, &#8220;G\u00f6receli referans\u0131 kullan&#8221; se\u00e7ene\u011fini etkinle\u015ftirin ve ayn\u0131 etkinli\u011fi kaydedin (E5 h\u00fccresini se\u00e7in).<\/li><li> Ancak \u015fu anda sahip oldu\u011funuz kod farkl\u0131d\u0131r:<\/li><\/ul><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub RelativeReferenceMacro() ActiveCell.Offset(4, 4).Range(\u201cA1\u201d).Select End Sub<\/code><\/pre><p> Bu iki kodu ayn\u0131 etkinli\u011fi ger\u00e7ekle\u015ftirerek ancak farkl\u0131 referans modlar\u0131n\u0131 kullanarak kaydettiniz. SA\u011e?<\/p><p> \u0130lk makro kodun anla\u015f\u0131lmas\u0131 olduk\u00e7a basittir; E5 h\u00fccresini se\u00e7in diyor.<\/p><p> Ve bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, ayn\u0131 \u015feyi yapar; bu noktada hangi h\u00fccreyi se\u00e7mi\u015f olursan\u0131z olun, E5 h\u00fccresini se\u00e7ersiniz.<\/p><p> \u00d6te yandan ikinci makro kodu ba\u015fka bir \u015fey s\u00f6yl\u00fcyor ve bu kodu \u00e7al\u0131\u015ft\u0131rmadan \u00f6nce ba\u015fka bir h\u00fccreyi se\u00e7erseniz farkl\u0131 bir h\u00fccreyi se\u00e7ecektir.<\/p><p> Ne i\u00e7in?<\/p><p> Bu makroyu kaydetti\u011finizde aktif h\u00fccre A1&#8217;di, ard\u0131ndan A1 h\u00fccresinin d\u00f6rt h\u00fccre a\u015fa\u011f\u0131s\u0131nda ve d\u00f6rt h\u00fccre sa\u011f\u0131nda olan E5&#8217;i se\u00e7tiniz.<\/p><p> Art\u0131k, bu makroyu g\u00f6receli bir referansla kaydetti\u011finiz i\u00e7in, bu her zaman etkin h\u00fccrenin d\u00f6rt h\u00fccre a\u015fa\u011f\u0131s\u0131nda ve d\u00f6rt h\u00fccre sa\u011f\u0131ndaki h\u00fccreyi se\u00e7ecektir.<\/p><p> Diyelim ki aktif h\u00fccre D4 ise d\u00f6rt h\u00fccre a\u015fa\u011f\u0131da ve d\u00f6rt h\u00fccre sa\u011fda olan H8 h\u00fccresini se\u00e7ecektir.<\/p><p class=\"content-box-blue\"> Referans\u0131 istedi\u011finiz zaman, hatta kayd\u0131n ortas\u0131nda bile de\u011fi\u015ftirebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Makro sonu<\/h2><p> Maalesef Excel, bir makroyu kaydederken duraklatman\u0131za izin vermez. Bu Microsoft Word&#8217;de m\u00fcmk\u00fcnd\u00fcr, ancak Excel&#8217;de m\u00fcmk\u00fcn de\u011fildir.<\/p><p> Bir\u00e7ok etkinli\u011fi ger\u00e7ekle\u015ftirmeniz gereken bir makroyu kaydediyorsan\u0131z, hata olas\u0131l\u0131\u011f\u0131n\u0131 azaltmak i\u00e7in bunu par\u00e7alar halinde kaydetmek en iyisidir.<\/p><h2 class=\"wp-block-heading\"> Makro Kaydedici S\u0131n\u0131rlamalar\u0131<\/h2><p> Evet, makro kaydediciyle birlikte baz\u0131 s\u0131n\u0131rlamalar gelir. VBA koduyla yapabilece\u011finiz pek \u00e7ok \u015fey var ancak makro kaydedici t\u00fcm etkinlikleri kaydedemez.<\/p><ul><li> <strong>\u00d6zel i\u015flev olu\u015fturulam\u0131yor<\/strong> : VBA, \u00e7al\u0131\u015fma sayfas\u0131nda kullanabilece\u011finiz <a href=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\">\u00f6zel bir i\u015flev<\/a> olu\u015fturman\u0131za olanak tan\u0131r, ancak makro kaydederken bu m\u00fcmk\u00fcn de\u011fildir.<\/li><li> <strong>Yerle\u015fik i\u015flevler kullan\u0131lam\u0131yor<\/strong> : VBA&#8217;n\u0131n kendi i\u015flevleri vard\u0131r ( <a href=\"https:\/\/exceladvisor.org\/tr\/islevler\/\">VBA \u0130\u015flevleri<\/a> ), ancak bunlar\u0131 makro kaydediciyle kullanamazs\u0131n\u0131z.<\/li><li> <strong>Ko\u015fullar test edilemiyor<\/strong> : Bir makro kaydederken ko\u015fullar\u0131 kontrol etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">VBA IF Then Else deyimini<\/a> kullanamazs\u0131n\u0131z.<\/li><li> <strong>D\u00f6ng\u00fc yap\u0131lam\u0131yor<\/strong> : VBA&#8217;da kod yazarken d\u00f6ng\u00fc ifadelerini kullanabilirsiniz ancak makro kaydedicide bu m\u00fcmk\u00fcn de\u011fildir.<\/li><li> <strong>Nesneyle etkinlik ger\u00e7ekle\u015ftirilemiyor<\/strong> : Bir makro kaydederken, bir nesneyi ger\u00e7ekten se\u00e7meden bir eylem ger\u00e7ekle\u015ftiremezsiniz. \u00d6rne\u011fin, belirli bir h\u00fccredeki metni kal\u0131nla\u015ft\u0131rmak istiyorsan\u0131z \u00f6nce o h\u00fccreyi se\u00e7melisiniz.<\/li><\/ul><h2 class=\"wp-block-heading\"> Makro kaydedici kullanmaya de\u011fer mi?<\/h2><p> Eminim akl\u0131n\u0131zda bu soru vard\u0131r ve bu do\u011frudur. Bu soruyu cevaplamak i\u00e7in sizinle ki\u015fisel bir hikayeyi payla\u015fay\u0131m.<\/p><p> Birka\u00e7 y\u0131l \u00f6nce <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-1\/\" data-wpil=\"url\">pivot tablo eklemek i\u00e7in baz\u0131 VBA kodlar\u0131<\/a> \u00fczerinde \u00e7al\u0131\u015f\u0131yordum ve o zamanlar bu kodu yazmak i\u00e7in kullanmam gereken t\u00fcm nesnelerin fark\u0131nda de\u011fildim. Ben de manuel olarak pivot tablo olu\u015ftururken bir makro kaydettim.<\/p><p> Daha sonra pivot tablo ekleme s\u00fcrecini anlamak i\u00e7in bu koda bakt\u0131m. Evet, bu kod m\u00fckemmel de\u011fildi ama bana yazma fikri verdi.<\/p><p> Demek istedi\u011fim, kod yazman\u0131z gereken durumlar olabilir ve o zaman makro kaydedici size yard\u0131mc\u0131 olabilir. Makro kaydedici ayr\u0131ca bu <a href=\"https:\/\/exceladvisor.org\/tr\/envanter-yonetimi-sablonu-excel-vba-kullanici-formlari\/\">envanter \u015fablonunun<\/a> kodlar\u0131n\u0131 yazmama da yard\u0131mc\u0131 oldu.<\/p><h2 class=\"wp-block-heading\"> <strong>D\u00fcr\u00fcm<\/strong><\/h2><p> Ba\u015far\u0131l\u0131 bir makro kaydetmek i\u00e7in a\u015fa\u011f\u0131daki noktalara odaklanmal\u0131s\u0131n\u0131z:<\/p><ul><li> Makroyu kaydedece\u011finiz ve di\u011fer t\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131n\u0131 kapataca\u011f\u0131n\u0131z \u00e7al\u0131\u015fma kitab\u0131n\u0131 tan\u0131mlay\u0131n.<\/li><li> Makroyu kaydetmek i\u00e7in do\u011fru nesneyi se\u00e7ti\u011finizden emin olun.<\/li><li> Makroyu kaydetmeden \u00f6nce mutlak m\u0131 yoksa g\u00f6reli referanslar m\u0131 kullanaca\u011f\u0131n\u0131za karar verdi\u011finizden emin olun.<\/li><li> Ger\u00e7ekle\u015ftirmek istedi\u011finiz eylemleri planlay\u0131n.<\/li><\/ul><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gorusme-sorulari\/\">VBA M\u00fclakat Sorular\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yorum\/\">VBA koduna yorum ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sonu\/\">VBA koduna sat\u0131r sonu ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yeni-hat\/\">VBA&#8217;da bir dizeye yeni bir sat\u0131r (sat\u0131r ba\u015f\u0131) ekleyin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Excel&#8217;de Makro \u00c7al\u0131\u015ft\u0131rma (VBA Kodunu \u00c7al\u0131\u015ft\u0131rma)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div><h2> S\u0131k\u00e7a Sorulan Sorular <\/h2><div class=\"schema-faq wp-block-yoast-faq-block\"><div id=\"faq-question-1585909163912\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">Makro kaydedici d\u00fc\u011fmesi nerede?<\/strong><p class=\"schema-faq-answer\"> Geli\u015ftirici sekmesindeki kod grubundad\u0131r.<\/p><\/div><div id=\"faq-question-1585909200861\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">Makro kaydedici taraf\u0131ndan olu\u015fturulan kodu nas\u0131l g\u00f6rebilirim?<\/strong><p class=\"schema-faq-answer\"> Bunu Visual Basic d\u00fczenleyicisinden g\u00f6rebilirsiniz.<\/p><\/div><div id=\"faq-question-1585909281389\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">Makro kaydedici m\u00fckemmel kod \u00fcretiyor mu?<\/strong><p class=\"schema-faq-answer\"> Pek de\u011fil, kaydettikten sonra bu kodu temizlemeniz gerekiyor.<\/p><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1490","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de makro nas\u0131l kaydedilir? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Makro kaydetmek, Excel&#039;de ger\u00e7ekle\u015ftirdi\u011finiz eylemleri kaydetmek anlam\u0131na gelir. i\u00e7in makro kaydediciyi kullanman\u0131z gerekir.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de makro nas\u0131l kaydedilir? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Makro kaydetmek, Excel&#039;de ger\u00e7ekle\u015ftirdi\u011finiz eylemleri kaydetmek anlam\u0131na gelir. i\u00e7in makro kaydediciyi kullanman\u0131z gerekir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"14 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\",\"name\":\"Excel&#39;de makro nas\u0131l kaydedilir? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif\",\"datePublished\":\"2023-11-21T17:33:52+00:00\",\"dateModified\":\"2023-12-10T06:01:36+00:00\",\"description\":\"Makro kaydetmek, Excel&#39;de ger\u00e7ekle\u015ftirdi\u011finiz eylemleri kaydetmek anlam\u0131na gelir. i\u00e7in makro kaydediciyi kullanman\u0131z gerekir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de makro nas\u0131l kaydedilir?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de makro nas\u0131l kaydedilir? (E\u011fitim 2023)","description":"Makro kaydetmek, Excel&#39;de ger\u00e7ekle\u015ftirdi\u011finiz eylemleri kaydetmek anlam\u0131na gelir. i\u00e7in makro kaydediciyi kullanman\u0131z gerekir.","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:\/\/exceladvisor.org\/tr\/makro-kaydet\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de makro nas\u0131l kaydedilir? (E\u011fitim 2023)","og_description":"Makro kaydetmek, Excel&#39;de ger\u00e7ekle\u015ftirdi\u011finiz eylemleri kaydetmek anlam\u0131na gelir. i\u00e7in makro kaydediciyi kullanman\u0131z gerekir.","og_url":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"14 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/","url":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/","name":"Excel&#39;de makro nas\u0131l kaydedilir? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif","datePublished":"2023-11-21T17:33:52+00:00","dateModified":"2023-12-10T06:01:36+00:00","description":"Makro kaydetmek, Excel&#39;de ger\u00e7ekle\u015ftirdi\u011finiz eylemleri kaydetmek anlam\u0131na gelir. i\u00e7in makro kaydediciyi kullanman\u0131z gerekir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/makro-kaydet\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-la-macro-dans-excel-et-obtenir-le-code.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de makro nas\u0131l kaydedilir?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1490"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1490\/revisions"}],"predecessor-version":[{"id":2542,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1490\/revisions\/2542"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}