{"id":1850,"date":"2023-10-31T12:32:23","date_gmt":"2023-10-31T12:32:23","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/"},"modified":"2023-12-10T06:06:22","modified_gmt":"2023-12-10T06:06:22","slug":"yapragi-korumak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/","title":{"rendered":"Vba kullanarak bir sayfay\u0131 koruma \/ korumadan kaldirma nas\u0131l yap\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-986314248\"><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>VBA&#8217;da sayfa ile kullanabilece\u011finiz PROTECT y\u00f6ntemi vard\u0131r. Bu y\u00f6ntemde, bir sayfay\u0131 \u015fifreli veya \u015fifresiz koruma se\u00e7ene\u011finiz vard\u0131r. Ayr\u0131ca bir nesneyi sayfadan da koruyabilirsiniz. T\u00fcm bunlar\u0131 bu e\u011fitimde ayr\u0131nt\u0131l\u0131 olarak g\u00f6rece\u011fiz.<\/p><p> E\u011fitimde, VBA kodunu kullanarak tek bir sayfay\u0131 veya birden fazla sayfay\u0131 nas\u0131l koruyaca\u011f\u0131m\u0131z\u0131 ve korumas\u0131n\u0131n nas\u0131l kald\u0131r\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Bir sayfay\u0131 korumak i\u00e7in VBA kodunu yaz\u0131n<\/h2><p> Bir sayfay\u0131 korumak i\u00e7in \u00f6nce sayfay\u0131 belirtmeniz, ard\u0131ndan koruma y\u00f6ntemini kullanman\u0131z gerekir. \u0130\u015fte ad\u0131mlar.<\/p><ol type=\"1\"><li> Sayfay\u0131 belirtmek i\u00e7in sayfalar nesnesini kullan\u0131n.<\/li><li> Korumak istedi\u011finiz sayfan\u0131n ad\u0131n\u0131 girin.<\/li><li> Y\u00f6ntem ve \u00f6zelliklerin listesini almak i\u00e7in bir nokta yaz\u0131n.<\/li><li> Proje y\u00f6ntemini se\u00e7in veya girin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52410\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png\" sizes=\"auto, \" srcset=\"\" alt=\"korunacak-sayfay\u0131-belirlemek i\u00e7in-sayfa-nesnesini-kullan\" width=\"339\" height=\"190\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(\"Sheet1\").Protect<\/code><\/pre><p class=\"content-box-grey\"> <em>Yararl\u0131 ba\u011flant\u0131lar: <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Makro \u00e7al\u0131\u015ft\u0131rma<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\">Makro kaydedici<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\">Visual Basic D\u00fczenleyici<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\">Ki\u015fisel Makrolar El Kitab\u0131<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Bir sayfan\u0131n korumas\u0131n\u0131 kald\u0131rmak i\u00e7in VBA kodunu yaz\u0131n<\/h2><p> Bir sayfay\u0131 korumak i\u00e7in \u00f6nce sayfay\u0131 belirtmeniz, ard\u0131ndan korumay\u0131 kald\u0131rma y\u00f6ntemini kullanman\u0131z gerekir. \u0130\u015fte ad\u0131mlar.<\/p><ol type=\"1\"><li> Sayfa nesnesini kullanarak sayfay\u0131 belirtin.<\/li><li> Daha sonra korumak istedi\u011finiz sayfan\u0131n ad\u0131n\u0131 girin.<\/li><li> Y\u00f6ntem ve \u00f6zelliklerin listesini almak i\u00e7in bir nokta girin.<\/li><li> \u201cKorumay\u0131 Kald\u0131r\u201d y\u00f6ntemini se\u00e7in veya girin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52411\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utilisez-lobjet-feuille-pour-specifier-la-feuille-a-deproteger.png\" sizes=\"auto, \" srcset=\"\" alt=\"korumas\u0131 kald\u0131r\u0131lacak sayfay\u0131 belirtmek i\u00e7in sayfa nesnesini kullan\u0131n\" width=\"393\" height=\"189\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(\"Sheet1\").Unprotect<\/code><\/pre><h2 class=\"wp-block-heading\"> Bir sayfay\u0131 parolayla koruma<\/h2><p> Bir sayfay\u0131 korurken parola ayarlamak istiyorsan\u0131z bu durumda parola belirlemek i\u00e7in parola ba\u011f\u0131ms\u0131z de\u011fi\u015fkenini kullanman\u0131z gerekir. Diyelim ki sayfay\u0131 korumak i\u00e7in \u201ctest123\u201d \u015fifresini ayarlamak istiyorsunuz, kod a\u015fa\u011f\u0131daki gibi olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52412\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-proteger-une-feuille-avec-un-mot-de-passe.png\" sizes=\"auto, \" srcset=\"\" alt=\"-bir-sayfay\u0131-\u015fifreyle-koru\" width=\"480\" height=\"174\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(\"Sheet1\").Protect Password:=\"test123\"<\/code><\/pre><h2 class=\"wp-block-heading\"> Bir sayfan\u0131n korumas\u0131n\u0131 parolayla kald\u0131rma<\/h2><p> Benzer \u015fekilde, bir sayfan\u0131n korumas\u0131n\u0131 kald\u0131rmak istiyorsan\u0131z parola arg\u00fcman\u0131nda parolay\u0131 belirtmeniz gerekir. Sayfay\u0131 korumak i\u00e7in kulland\u0131\u011f\u0131n\u0131z \u015fifrenin &#8220;ADSBP&#8221; oldu\u011funu varsayal\u0131m, dolay\u0131s\u0131yla korumay\u0131 kald\u0131racak kod a\u015fa\u011f\u0131daki gibi olacakt\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(\"Sheet1\").Unprotect Password:=\"ADSBP\"<\/code><\/pre><p> Dikkat etmeniz gereken bir \u015fey var, b\u00fcy\u00fck harfe dikkat edin \u00e7\u00fcnk\u00fc VBA b\u00fcy\u00fck ve k\u00fc\u00e7\u00fck harf ayr\u0131m\u0131 yap\u0131yor.<\/p><h2 class=\"wp-block-heading\"> Bilinmesi gereken di\u011fer \u015feyler<\/h2><p> Dedi\u011fim gibi VBA&#8217;n\u0131n &#8220;Protect&#8221; y\u00f6ntemini kullan\u0131yoruz ve bu y\u00f6ntemle &#8220;Password&#8221; d\u0131\u015f\u0131nda kullanabilece\u011finiz arg\u00fcmanlar da mevcut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">expression.Protect (Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)<\/code><\/pre><ol type=\"1\"><li> <strong>DrawingObjects<\/strong> : \u015eekilleri korumak ve korumay\u0131 kald\u0131rmak i\u00e7in.<\/li><li> <strong>\u0130\u00e7erik<\/strong> : Kilitli h\u00fccreleri ve t\u00fcm grafi\u011fi korumak \u0130\u00c7\u0130N.<\/li><li> <strong>Senaryolar<\/strong> : Elektronik tablodaki senaryolar\u0131 korumak i\u00e7in.<\/li><li> <strong>UserInterfaceOnly<\/strong> : Makrolar\u0131 de\u011fil, yaln\u0131zca kullan\u0131c\u0131 aray\u00fcz\u00fcn\u00fc korumak i\u00e7in.<\/li><li> <strong>AllowFormattingCells<\/strong> : Kullan\u0131c\u0131n\u0131n h\u00fccrelere bi\u00e7imlendirme uygulamas\u0131na izin vermek i\u00e7in.<\/li><li> <strong>AllowFormattingColumns<\/strong> : Kullan\u0131c\u0131n\u0131n s\u00fctunlara bi\u00e7imlendirme uygulamas\u0131na izin vermek i\u00e7in.<\/li><li> <strong>AllowFormattingRows<\/strong> : kullan\u0131c\u0131n\u0131n sat\u0131rlara bi\u00e7imlendirme uygulamas\u0131na izin vermek i\u00e7in.<\/li><li> <strong>AllowInsertingColumns<\/strong> : kullan\u0131c\u0131n\u0131n yeni s\u00fctunlar eklemesine izin vermek i\u00e7in.<\/li><li> <strong>AllowInsertingRows<\/strong> : Kullan\u0131c\u0131n\u0131n yeni sat\u0131rlar eklemesine izin vermek i\u00e7in.<\/li><li> <strong>AllowInsertingHyperlinks<\/strong> : Kullan\u0131c\u0131n\u0131n k\u00f6pr\u00fcler olu\u015fturmas\u0131na izin vermek i\u00e7in.<\/li><li> <strong>AllowDeletingColumns<\/strong> : kullan\u0131c\u0131n\u0131n s\u00fctunlar\u0131 silmesine izin vermek i\u00e7in.<\/li><li> <strong>AllowDeletingRows<\/strong> : Kullan\u0131c\u0131n\u0131n sat\u0131rlar\u0131 silmesine izin vermek i\u00e7in.<\/li><li> <strong>S\u0131ralamaya izin ver<\/strong> : Kullan\u0131c\u0131n\u0131n sat\u0131rlar\u0131, s\u00fctunlar\u0131 ve tablolar\u0131 s\u0131ralamas\u0131na olanak tan\u0131r.<\/li><li> <strong>AllowFiltering<\/strong> : S\u00fctunlar\u0131n filtrelenmesine izin vermek i\u00e7in.<\/li><li> <strong>AllowUsingPivotTables<\/strong> : Kullan\u0131c\u0131n\u0131n pivot tablo kullanmas\u0131na izin vermek i\u00e7in.<\/li><\/ol><h2 class=\"wp-block-heading\"> Yorumlar<\/h2><ul><li> B\u00fcy\u00fck ve k\u00fc\u00e7\u00fck harfleri, say\u0131lar\u0131 ve simgeleri birle\u015ftiren g\u00fc\u00e7l\u00fc \u015fifreler kulland\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><li> Parolan\u0131z\u0131 unutursan\u0131z Microsoft parolan\u0131z\u0131 kurtaramaz. Bu nedenle \u015fifrenizi g\u00fcvenli bir yere yazd\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><li> Bir sayfa \u015fifresiz korunuyorsa ve \u015fimdi onu \u015fifreyle korumak istiyorsan\u0131z, \u00f6nce korumay\u0131 kald\u0131rmal\u0131s\u0131n\u0131z. Daha sonra yukar\u0131da g\u00f6rd\u00fc\u011f\u00fcn\u00fcz kodu kullanarak \u015fifre ile tekrar koruma alt\u0131na al\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\/temiz-sayfa\/\">Excel&#8217;de VBA kullanarak bir sayfan\u0131n tamam\u0131n\u0131 TEM\u0130ZLEY\u0130N<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-kopyala\/\">VBA&#8217;y\u0131 kullanarak Excel&#8217;de bir sayfay\u0131 kopyalay\u0131n ve ta\u015f\u0131y\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/\">Excel&#8217;de VBA kullanan COUNT Sayfa<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-sayfayi-sil-1\/\">Excel&#8217;de VBA kullanarak bir SAYFAYI S\u0130L\u0130N<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-gizle\/\">Excel&#8217;de VBA kullanarak bir sayfay\u0131 gizleme ve g\u00f6sterme<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1850","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>VBA kullanarak bir sayfay\u0131 KORUMA\/KORUMADAN KALDIRMA<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim, VBA kodunu kullanarak bir sayfay\u0131 nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ve korumay\u0131 nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmenize yard\u0131mc\u0131 olur. Birini koruma olana\u011f\u0131n\u0131z var\" \/>\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\/yapragi-korumak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA kullanarak bir sayfay\u0131 KORUMA\/KORUMADAN KALDIRMA\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim, VBA kodunu kullanarak bir sayfay\u0131 nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ve korumay\u0131 nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmenize yard\u0131mc\u0131 olur. Birini koruma olana\u011f\u0131n\u0131z var\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:06:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.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=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/\",\"name\":\"VBA kullanarak bir sayfay\u0131 KORUMA\/KORUMADAN KALDIRMA\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png\",\"datePublished\":\"2023-10-31T12:32:23+00:00\",\"dateModified\":\"2023-12-10T06:06:22+00:00\",\"description\":\"Bu e\u011fitim, VBA kodunu kullanarak bir sayfay\u0131 nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ve korumay\u0131 nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmenize yard\u0131mc\u0131 olur. Birini koruma olana\u011f\u0131n\u0131z var\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kullanarak bir sayfay\u0131 koruma \/ korumadan kaldirma nas\u0131l yap\u0131l\u0131r?\"}]},{\"@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":"VBA kullanarak bir sayfay\u0131 KORUMA\/KORUMADAN KALDIRMA","description":"Bu e\u011fitim, VBA kodunu kullanarak bir sayfay\u0131 nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ve korumay\u0131 nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmenize yard\u0131mc\u0131 olur. Birini koruma olana\u011f\u0131n\u0131z var","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\/yapragi-korumak\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA kullanarak bir sayfay\u0131 KORUMA\/KORUMADAN KALDIRMA","og_description":"Bu e\u011fitim, VBA kodunu kullanarak bir sayfay\u0131 nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ve korumay\u0131 nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmenize yard\u0131mc\u0131 olur. Birini koruma olana\u011f\u0131n\u0131z var","og_url":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:06:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/","url":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/","name":"VBA kullanarak bir sayfay\u0131 KORUMA\/KORUMADAN KALDIRMA","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png","datePublished":"2023-10-31T12:32:23+00:00","dateModified":"2023-12-10T06:06:22+00:00","description":"Bu e\u011fitim, VBA kodunu kullanarak bir sayfay\u0131 nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ve korumay\u0131 nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmenize yard\u0131mc\u0131 olur. Birini koruma olana\u011f\u0131n\u0131z var","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-lobjet-feuille-pour-specifier-la-feuille-a-proteger.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kullanarak bir sayfay\u0131 koruma \/ korumadan kaldirma nas\u0131l yap\u0131l\u0131r?"}]},{"@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\/1850","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=1850"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1850\/revisions"}],"predecessor-version":[{"id":2866,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1850\/revisions\/2866"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}