{"id":2050,"date":"2023-10-22T18:15:46","date_gmt":"2023-10-22T18:15:46","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/"},"modified":"2023-12-10T06:01:27","modified_gmt":"2023-12-10T06:01:27","slug":"kisisel-makro-not-defteri","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/","title":{"rendered":"Excel&#39;de ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1448542126\"><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>E\u011fer benim gibi \u00e7ok fazla VBA kodu kullan\u0131yorsan\u0131z hepsini saklayabilece\u011finiz ve ihtiya\u00e7 duydu\u011funuzda kullanabilece\u011finiz bir yere ihtiyac\u0131n\u0131z var.<\/p><p> Ama soru \u015fu ki, bunun i\u00e7in en iyi yer neresi? <strong>MAKRO&#8217;NUN K\u0130\u015e\u0130SEL DEFTER\u0130<\/strong> . Evet, bu PERSONAL.XLBS ba\u011flay\u0131c\u0131. \u0130\u015fte \u00e7\u0131lg\u0131nca \u015fey:<\/p><p> <span style=\"color: #000000;\">Ki\u015fisel bir makro \u00e7al\u0131\u015fma kitab\u0131 olu\u015fturmak ve <strong>t\u00fcm \u00f6nemli makrolar\u0131 saklamak<\/strong> size \u00e7ok zaman kazand\u0131rabilir<\/span> ve bunlar\u0131 t\u00fcm Excel dosyalar\u0131nda kullanman\u0131za yard\u0131mc\u0131 olabilir.<\/p><p> Bu harika de\u011fil mi? Ve bug\u00fcn bu yaz\u0131mda sizlerle bu dosya hakk\u0131nda bilmeniz gereken her \u015feyi payla\u015faca\u011f\u0131m. \u00d6n\u00fcm\u00fczdeki 3-4 dakika benimle kal.<\/p><h2 class=\"wp-block-heading\"> K\u0130\u015e\u0130SEL MAKRO DEFTER NED\u0130R?<\/h2><p> Ki\u015fisel Makro \u00c7al\u0131\u015fma Kitab\u0131, t\u00fcm makrolar\u0131n\u0131z\u0131 saklayabilece\u011finiz ve kullanabilece\u011finiz ortak depolama yeri olabilecek bir dosyad\u0131r. Sisteminizde Excel&#8217;i ba\u015flatt\u0131\u011f\u0131n\u0131zda a\u00e7\u0131lan gizli bir dosya olmas\u0131na ra\u011fmen. \u00dcstelik i\u00e7erdi\u011fi kodlardan herhangi birine eri\u015fmek istedi\u011finizde ayr\u0131ca a\u00e7man\u0131za da gerek yok. Ortaya \u00e7\u0131kan t\u00fcm kodlar\u0131 makro listenizde g\u00f6rebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> PERSONAL.XLSB \u00e7al\u0131\u015fma kitab\u0131n\u0131n KONUMU nedir<\/h2><p> \u0130\u015fte k\u00f6t\u00fc haber: Sahip olunmas\u0131 \u00e7ok yararl\u0131 bir \u015fey olmas\u0131na ra\u011fmen, <strong><span style=\"color: #000000;\">Excel&#8217;de varsay\u0131lan olarak mevcut de\u011fildir<\/span><\/strong> , bu y\u00fczden onu olu\u015fturman\u0131z gerekir (bu yaz\u0131da ilerideki ad\u0131mlar\u0131 payla\u015ft\u0131m). Ancak \u00f6nceden olu\u015fturulup olu\u015fturulmad\u0131\u011f\u0131n\u0131 kontrol edebilirsiniz.<\/p><p> <strong><span style=\"color: #000000;\">\u0130lk y\u00f6ntem<\/span><\/strong> , Visual Basic edit\u00f6r\u00fcn\u00fcz\u00fc a\u00e7makt\u0131r ve proje pencerenizde &#8220;PERSONAL.XLBS&#8221; isimli bir dosya listelediyseniz. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-create-personal.-xlsb-macro=\u00e7al\u0131\u015fma kitab\u0131-a\u00e7\u0131k-vb-d\u00fczenleyici-kontrol edilecek\" width=\"274\" height=\"195\"><\/figure><\/div><p> Bu, onun zaten orada oldu\u011fu ve onu yaratmaya gerek olmad\u0131\u011f\u0131 anlam\u0131na gelir. <strong><span style=\"color: #000000;\">\u0130kinci y\u00f6ntem<\/span><\/strong> ise XLSTART dosyan\u0131za ba\u015fvurmakt\u0131r.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> XLSTART klas\u00f6r\u00fcne bir \u015fey koyarsan\u0131z Excel&#8217;i ba\u015flatt\u0131\u011f\u0131n\u0131zda otomatik olarak a\u00e7\u0131l\u0131r. Windows 10 kullan\u0131yorsan\u0131z:<\/p><p> <span style=\"font-family: Verdana, Geneva, sans-serif; font-size: 14px;\">C:Kullan\u0131c\u0131larPune ve GogiaAppDataRoamingMicrosoftExcelXLSTART<\/span> <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macros-xlsb-personnel-dans-les-fenetres-du-dossier-de-demarrage-Excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir-excel-windows-ba\u015flang\u0131\u00e7-klas\u00f6r\u00fcnde-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131n\u0131-olu\u015fturmak i\u00e7in\" width=\"509\" height=\"184\"><\/figure><\/div><p> MAC kullan\u0131yorsan\u0131z: Kitapl\u0131k \u25b8 Grup Kapsay\u0131c\u0131lar \u25b8 UBF8T346G9.Office \u25b8 Kullan\u0131c\u0131 \u0130\u00e7eri\u011fi \u25b8 Ba\u015flang\u0131\u00e7 \u25b8 Excel <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel-1.png\" sizes=\"\" srcset=\"\" alt=\"excel-create-ki\u015fisel.-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131-mac-konumu\"><\/figure><\/div><p> Bu y\u00f6ntemleri kullanarak ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 bulam\u0131yorsan\u0131z yukar\u0131da bahsetti\u011fim ad\u0131mlar\u0131 takip ederek yeni bir makro \u00e7al\u0131\u015fma kitab\u0131 olu\u015fturman\u0131z gerekir.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de Ki\u015fisel Makro \u00c7al\u0131\u015fma Kitab\u0131 Nas\u0131l Olu\u015fturulur<\/h2><p> Yeni bir ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 olu\u015fturmak basittir. Tek yapman\u0131z gereken bir makro kaydetmek, i\u015fte bu kadar, bu kadar.<\/p><h3 class=\"wp-block-heading\"> Windows s\u00fcr\u00fcm\u00fc<\/h3><p> \u0130zlemeniz gereken basit ad\u0131mlar \u015funlard\u0131r:<\/p><ul><li> \u00d6ncelikle geli\u015ftirici sekmesine gidin ve \u201cMakrolar\u0131 Kaydet\u201d butonuna t\u0131klay\u0131n. <\/li><\/ul><figure class=\"wp-block-image is-style-default\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macro-xlsb-personnel-dans-Excel-Windows-accedez-a-longlet-developpeur-et-cliquez-sur-enregistrer-la-macro-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Windows'ta ki\u015fisel bir xlsb makro \u00e7al\u0131\u015fma kitab\u0131 olu\u015fturmak i\u00e7in Geli\u015ftirici sekmesine gidin ve Makroyu Kaydet'e t\u0131klay\u0131n.\"><\/figure><ul><li> Bundan sonra \u201cMakro Kaydet\u201d ileti\u015fim kutusunda:<ol><li> Makro i\u00e7in bir ad girin<\/li><li> &#8220;Makroyu kaydet&#8221; a\u00e7\u0131l\u0131r listesinde &#8220;Ki\u015fisel \u0130leti\u015fim Kutusu&#8221;nu se\u00e7in. <\/li><\/ol><\/li><\/ul><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macros-xlsb-personnel-dans-Excel-Windows-selectionnez-dans-la-liste-deroulante-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel-Windows'ta-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131 olu\u015fturmak i\u00e7in a\u00e7\u0131l\u0131r men\u00fcden se\u00e7im yap\u0131n\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k bir \u015feyler kaydedebilir veya \u201cKayd\u0131 Durdur\u201da t\u0131klayabilirsiniz. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macro-xlsb-personnel-dans-Excel-Windows-arreter-lenregistrement-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-windows-bir-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131 olu\u015ftur-kaydetmeyi durdur\" width=\"283\" height=\"180\"><\/figure><\/div><p> Yeni \u201cKi\u015fisel Makro Dosyan\u0131z\u201d art\u0131k olu\u015fturuldu. Yeni PERSONAL.XLSB dosyas\u0131n\u0131 XLSTART klas\u00f6r\u00fcnde bulabilirsiniz. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macros-xlsb-personnel-dans-Excel-dans-le-dossier-de-demarrage-1.png\" sizes=\"\" srcset=\"\" alt=\"ba\u015flang\u0131\u00e7-klas\u00f6r\u00fcnde-excel-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131 olu\u015ftur\" width=\"-122\" height=\"-44\"><\/figure><\/div><h3 class=\"wp-block-heading\"> (MAC Versiyonu)<\/h3><p> A\u015fa\u011f\u0131da, Excel&#8217;in MAC s\u00fcr\u00fcm\u00fcnde ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 olu\u015fturma ad\u0131mlar\u0131 verilmi\u015ftir.<\/p><ul><li> \u00d6ncelikle geli\u015ftirici sekmesine gidin ve \u201cMakro Kaydet D\u00fc\u011fmesine\u201d t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macro-xlsb-personnel-dans-excel-mac-cliquez-sur-enregistrer-la-macro-1.png\" sizes=\"\" srcset=\"\" alt=\"excel-mac'te-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131 olu\u015fturmak i\u00e7in-kay\u0131t-makrosunu t\u0131klay\u0131n\"><\/figure><\/div><ul><li> Bundan sonra makro ad\u0131n\u0131 girin ve a\u00e7\u0131l\u0131r listeden \u201cKi\u015fisel Makro \u00c7al\u0131\u015fma Kitab\u0131\u201dn\u0131 se\u00e7in. <\/li><\/ul><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macro-xlsb-personnel-dans-excel-mac-selectionnez-dans-le-menu-deroulant-1.png\" sizes=\"\" srcset=\"\" alt=\"excel-mac'te-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131 olu\u015fturmak i\u00e7in a\u00e7\u0131l\u0131r men\u00fcden se\u00e7im yap\u0131n\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k yeni ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131z olu\u015fturuldu\u011funda &#8220;Kayd\u0131 Durdur&#8221;a t\u0131klaman\u0131z yeterlidir. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-creer-un-classeur-de-macros-xlsb-personnel-dans-excel-mac-arreter-lenregistrement-1.png\" sizes=\"\" srcset=\"\" alt=\"excel-mac'te-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131 olu\u015fturmak i\u00e7in-kaydetmeyi durdurun\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Neden ki\u015fisel bir makro dosyaya sahip olmal\u0131y\u0131m?<\/h2><p> As\u0131l soru bu&#8230;<\/p><p> E\u011fer makrolar\u0131 kullanmay\u0131 seviyorsan\u0131z ve tek t\u0131klamayla i\u015flerinizi halletmenize yard\u0131mc\u0131 olacak faydal\u0131 kodlara sahipseniz o zaman ki\u015fisel bir makro \u00e7al\u0131\u015fma kitab\u0131n\u0131z olmal\u0131. T\u00fcm bu kodlar\u0131 ki\u015fisel \u00e7al\u0131\u015fma kitab\u0131n\u0131zda saklayabilir ve sisteminizdeki herhangi bir \u00e7al\u0131\u015fma kitab\u0131ndan kullanabilirsiniz.<\/p><p> Dedi\u011fim gibi Excel&#8217;inizi a\u00e7t\u0131\u011f\u0131n\u0131zda \u201cPERSONAL.XLSB\u201d onunla birlikte a\u00e7\u0131l\u0131yor, b\u00f6ylece Excel&#8217;i kulland\u0131\u011f\u0131n\u0131zda kodlar\u0131n\u0131za her zaman ula\u015fabilirsiniz. Yani buna sahip olmak b\u00fcy\u00fck bir KAZAN-KAZAN&#8217;d\u0131r.<\/p><h2 class=\"wp-block-heading\"> Ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131m\u0131 ba\u015fkalar\u0131yla payla\u015fabilir miyim?<\/h2><p> Bu bazen Ki\u015fisel Makro Ciltleyicideki makrolar\u0131n\u0131z\u0131 ba\u015fkalar\u0131yla payla\u015fman\u0131z gerekti\u011finde veya bunlar\u0131 yaln\u0131zca ba\u015fka bir sisteme aktarman\u0131z gerekti\u011finde meydana gelir. \u015eimdi bu durumda a\u015fa\u011f\u0131dakileri kullanabilirsiniz:<\/p><h3 class=\"wp-block-heading\"> (A) \u0130hracat ve ithalat mod\u00fcl\u00fc<\/h3><p> Ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 payla\u015fman\u0131n veya aktarman\u0131n en iyi yolu, VB mod\u00fcl\u00fcn\u00fc bir sistemden d\u0131\u015fa aktar\u0131p di\u011fer sisteme i\u00e7e aktarmakt\u0131r. Bunu yapmak i\u00e7in kullanabilece\u011finiz ad\u0131mlar \u015funlard\u0131r:<\/p><ul><li> \u00d6ncelikle VB edit\u00f6r\u00fcn\u00fc a\u00e7\u0131n ve \u201cPersonal.xlsb\u201dnin a\u011fa\u00e7 g\u00f6r\u00fcn\u00fcm\u00fcn\u00fc geni\u015fletin ve d\u0131\u015fa aktarmak istedi\u011finiz mod\u00fcle sa\u011f t\u0131klay\u0131n.<\/li><li> \u015eimdi \u201cDosyay\u0131 D\u0131\u015fa Aktar\u201d se\u00e7ene\u011fini se\u00e7in ve masa\u00fcst\u00fcne kaydedin ve ard\u0131ndan yeni sisteme aktar\u0131n.<\/li><li> O zaman yeni sisteme VB edit\u00f6r\u00fcn\u00fc de\u011fil bu mod\u00fcl\u00fc aktarman\u0131z gerekir.<\/li><li> Bunu yapmak i\u00e7in VB edit\u00f6r\u00fcn\u00fc a\u00e7\u0131n ve \u201cPersonal.xlsb\u201dye sa\u011f t\u0131klay\u0131n ve \u201cDosyay\u0131 \u0130\u00e7e Aktar\u201d\u0131 se\u00e7in. <\/li><\/ul><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-classeur-de-macro-xlsb-personnel-dans-lexportation-Excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"345\" height=\"555\"><\/figure><\/div><ul><li> Bundan sonra mod\u00fcl dosyas\u0131na g\u00f6z at\u0131n ve i\u00e7e aktarmak i\u00e7in Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131zda t\u00fcm VBA kodlar\u0131n\u0131n bulundu\u011fu ve bunlar\u0131 makro listesinden kullanabilece\u011finiz yeni mod\u00fcle sahipsiniz.<\/p><h3 class=\"wp-block-heading\"> (B) Personal.xlsb dosyas\u0131n\u0131 kopyalay\u0131p Ba\u015flang\u0131\u00e7 klas\u00f6r\u00fcne yap\u0131\u015ft\u0131r\u0131n<\/h3><p> T\u00fcm kodlar\u0131 aktarmak istedi\u011finiz yeni sistemin ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 yoksa, ki\u015fisel.xlsb dosyas\u0131n\u0131 eski sistemden kopyalay\u0131p yeni sistemin Excel ba\u015flang\u0131\u00e7 klas\u00f6r\u00fcne yap\u0131\u015ft\u0131rman\u0131z yeterlidir.<\/p><p> Evet, bu o.<\/p><h2 class=\"wp-block-heading\"> Ki\u015fisel Makro \u00c7al\u0131\u015fma Kitab\u0131n\u0131 Sil<\/h2><p> Ki\u015fisel bir makro klas\u00f6r\u00fcn\u00fcz\u00fcn olmas\u0131n\u0131 istemiyorsan\u0131z sisteminizden silmeniz yeterlidir. Tek yapman\u0131z gereken Excel BA\u015eLANGI\u00c7 klas\u00f6r\u00fcn\u00fc a\u00e7mak ve dosyay\u0131 oradan silmek.<\/p><p> Ve e\u011fer PERSONAL.XLSB dosyas\u0131 gizliyse, onu g\u00f6stermeniz ve ard\u0131ndan silmeniz yeterlidir. \u00d6neri, daha sonra geri y\u00fckleyebilmeniz i\u00e7in ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131 kurtarman\u0131zd\u0131r.<\/p><h2 class=\"wp-block-heading\"> Bir makroyu ki\u015fisel makro klas\u00f6r\u00fcme kaydedemiyorsam ne yapmal\u0131y\u0131m?<\/h2><p> Ki\u015fisel Makro \u00c7al\u0131\u015fma Kitab\u0131&#8217;na makro kaydedemeyebilirsiniz. Ancak Excel&#8217;i ba\u015flatt\u0131\u011f\u0131n\u0131zda a\u00e7\u0131lm\u0131yor.<\/p><p> Bu durumda ki\u015fisel makrolar klas\u00f6r\u00fcn\u00fcz\u00fcn \u201cDevre D\u0131\u015f\u0131 \u00d6\u011feler\u201d alt\u0131nda olup olmad\u0131\u011f\u0131n\u0131 kontrol etmeniz gerekir. E\u011fer \u00f6yleyse, etkinle\u015ftirmeniz gerekir. \u201cDevre D\u0131\u015f\u0131 \u00d6\u011feler\u201di a\u00e7mak i\u00e7in Dosya sekmesine gidin \u279c Se\u00e7enekler \u279c Eklentiler \u279c Y\u00f6net \u279c Devre D\u0131\u015f\u0131 \u00d6\u011feler. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-classeur-de-macro-xlsb-personnel-dans-excel-cliquer-sur-aller-1.png\" sizes=\"\" srcset=\"\" alt=\"create-makro-\u00e7al\u0131\u015fma kitab\u0131-xlsb-ki\u015fisel-in-excel-click-go\"><\/figure><\/div><p> Bu ileti\u015fim kutusundan bunu kolayca etkinle\u015ftirebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Excel her zaman a\u00e7maya devam ederse gizle<\/h2><p> Bildi\u011finiz gibi Excel&#8217;i her a\u00e7t\u0131\u011f\u0131n\u0131zda Personal.xlsb dosyas\u0131 otomatik olarak onunla birlikte a\u00e7\u0131l\u0131yor ancak bazen gizli dosya olarak a\u00e7mak yerine \u00f6nden a\u00e7\u0131l\u0131yor.<\/p><p> Saklanmas\u0131n\u0131 sa\u011flayabilirsin. Tek yapman\u0131z gereken Excel uygulaman\u0131z\u0131 a\u00e7mak, G\u00f6r\u00fcn\u00fcm sekmesine gidip &#8220;Gizle&#8221;ye t\u0131klay\u0131p &#8220;Ki\u015fisel&#8221;i se\u00e7mek. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-classeur-de-macro-xlsb-personnel-dans-excel-cliquez-sur-masquer-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel'de-makro-xlsb-ki\u015fisel-\u00e7al\u0131\u015fma kitab\u0131 olu\u015ftur-t\u0131kla-gizle\" width=\"353\" height=\"152\"><\/figure><\/div><p> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. \u015eimdi Excel&#8217;i kapat\u0131n ve yeniden ba\u015flat\u0131n. Bu kadar.<\/p><h2 class=\"wp-block-heading\"> Di\u011fer VBA kodunu ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131na aktar\u0131n<\/h2><p> Makro kodunuzu Personal.xlsb&#8217;ye kaydedip yazmak her zaman en iyisidir, ancak K\u0130\u015e\u0130SEL MAKRO \u00c7ALI\u015eMA K\u0130TABI&#8217;n\u0131 olu\u015fturmadan \u00f6nce sahip oldu\u011funuz t\u00fcm kodlar i\u00e7in.<\/p><p> Bu \u015fey basit. Tek yapman\u0131z gereken yeni bir mod\u00fcl olu\u015fturmak ve ard\u0131ndan t\u00fcm kodu bu mod\u00fcle yap\u0131\u015ft\u0131rmak.<\/p><h2 class=\"wp-block-heading\"> D\u00fczenleme i\u00e7in Personal.xlsb dosyas\u0131n\u0131 kilitleyin<\/h2><p> Ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 d\u00fczenlenemeyecek \u015fekilde kilitlemek istiyorsan\u0131z a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uygulaman\u0131z yeterlidir:<\/p><ul><li> \u00d6ncelikle Personal.xlsb dosyas\u0131n\u0131n bulundu\u011fu yere gidin ve sa\u011f t\u0131klay\u0131p \u00f6zelliklerini a\u00e7\u0131n.<\/li><li> Bundan sonra, \u201cG\u00fcvenlik\u201d sekmesinde \u201cSalt Okunur\u201d kutusunu i\u015faretleyin. <\/li><\/ul><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-classeur-de-macro-xlsb-personnel-dans-une-coche-excel-en-lecture-seule-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-ki\u015fisel-xlsb-makro-\u00e7al\u0131\u015fma kitab\u0131-in-excel-onay i\u015fareti-salt okunur\" width=\"415\" height=\"187\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Bunu yapt\u0131ktan sonra makroyu buradan oynatabilirsiniz ancak ona yeni bir makro kaydedemezsiniz.<\/p><h2 class=\"wp-block-heading\"> Sonunda,<\/h2><p> Ki\u015fisel bir makro ba\u011flay\u0131c\u0131, t\u00fcm \u00f6nemli makrolar\u0131 tek bir yerden y\u00f6netmenize yard\u0131mc\u0131 olabilir. Personal.xlsb dosyas\u0131 olu\u015fturman\u0131n en iyi yolu, i\u00e7ine bir makro kaydetmektir. Umar\u0131m bu <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\" data-wpel-link=\"internal\" data-wpil=\"url\">VBA ipucunun<\/a> <strong>VBA&#8217;y\u0131 <em>daha h\u0131zl\u0131<\/em> \u00f6\u011frenmenize<\/strong> yard\u0131mc\u0131 olaca\u011f\u0131n\u0131 bulmu\u015fsunuzdur <em>.<\/em><\/p><p> Ama \u015fimdi bana bir \u015feyi s\u00f6yle.<\/p><p> <em>Kulland\u0131\u011f\u0131n\u0131z t\u00fcm VBA kodlar\u0131n\u0131 nas\u0131l y\u00f6netiyorsunuz?<\/em><\/p><p> G\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015fmay\u0131 unutmay\u0131n, sizden haber almay\u0131 \u00e7ok isterim ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim yapacaklard\u0131r. takdir edecek.<\/p><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>","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-2050","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 ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"T\u00fcm VBA kodlar\u0131n\u0131z\u0131 tek bir yerde depolamak ve bunlara her \u00e7al\u0131\u015fma kitab\u0131ndan eri\u015fmek i\u00e7in PERSONAL.XLSB dosyas\u0131n\u0131 nas\u0131l olu\u015fturaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.\" \/>\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\/kisisel-makro-not-defteri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"T\u00fcm VBA kodlar\u0131n\u0131z\u0131 tek bir yerde depolamak ve bunlara her \u00e7al\u0131\u015fma kitab\u0131ndan eri\u015fmek i\u00e7in PERSONAL.XLSB dosyas\u0131n\u0131 nas\u0131l olu\u015fturaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png\" \/>\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=\"8 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\",\"name\":\"Excel&#39;de ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png\",\"datePublished\":\"2023-10-22T18:15:46+00:00\",\"dateModified\":\"2023-12-10T06:01:27+00:00\",\"description\":\"T\u00fcm VBA kodlar\u0131n\u0131z\u0131 tek bir yerde depolamak ve bunlara her \u00e7al\u0131\u015fma kitab\u0131ndan eri\u015fmek i\u00e7in PERSONAL.XLSB dosyas\u0131n\u0131 nas\u0131l olu\u015fturaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?\"}]},{\"@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 ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?","description":"T\u00fcm VBA kodlar\u0131n\u0131z\u0131 tek bir yerde depolamak ve bunlara her \u00e7al\u0131\u015fma kitab\u0131ndan eri\u015fmek i\u00e7in PERSONAL.XLSB dosyas\u0131n\u0131 nas\u0131l olu\u015fturaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.","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\/kisisel-makro-not-defteri\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?","og_description":"T\u00fcm VBA kodlar\u0131n\u0131z\u0131 tek bir yerde depolamak ve bunlara her \u00e7al\u0131\u015fma kitab\u0131ndan eri\u015fmek i\u00e7in PERSONAL.XLSB dosyas\u0131n\u0131 nas\u0131l olu\u015fturaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.","og_url":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"8 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/","url":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/","name":"Excel&#39;de ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png","datePublished":"2023-10-22T18:15:46+00:00","dateModified":"2023-12-10T06:01:27+00:00","description":"T\u00fcm VBA kodlar\u0131n\u0131z\u0131 tek bir yerde depolamak ve bunlara her \u00e7al\u0131\u015fma kitab\u0131ndan eri\u015fmek i\u00e7in PERSONAL.XLSB dosyas\u0131n\u0131 nas\u0131l olu\u015fturaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-creer-personnel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l olu\u015fturulur?"}]},{"@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\/2050","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=2050"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2050\/revisions"}],"predecessor-version":[{"id":2523,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2050\/revisions\/2523"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}