{"id":2161,"date":"2023-09-27T15:58:58","date_gmt":"2023-09-27T15:58:58","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/"},"modified":"2023-12-10T06:06:20","modified_gmt":"2023-12-10T06:06:20","slug":"sayfayi-etkinlestir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/","title":{"rendered":"Vba kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3603239161\"><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>Diyelim ki birden fazla \u00e7al\u0131\u015fma sayfas\u0131yla \u00e7al\u0131\u015f\u0131yorsunuz ve sekmeyi kullanarak bir sayfaya gitmeniz zor. Bu durumda herhangi bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in VBA kodunu kullanabilirsiniz.<\/p><p> Ve bunun i\u00e7in VBA kodu yazmak i\u00e7in Worksheet.Activate y\u00f6ntemini kullanman\u0131z gerekir. Bu yaz\u0131da, bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek veya se\u00e7mek i\u00e7in bu kodu yazman\u0131n kolay bir yolunu sizinle payla\u015fmak istiyorum. Bu kodu yazmadan \u00f6nce bu y\u00f6ntemi anlamal\u0131s\u0131n\u0131z.<\/p><h2 class=\"wp-block-heading\"> Worksheet.Activate y\u00f6ntemi<\/h2><p> Bu y\u00f6ntemde etkinle\u015ftirmek istedi\u011finiz \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131n\u0131 veya numaras\u0131n\u0131 belirtebilirsiniz. Diyelim ki 1. sayfay\u0131 etkinle\u015ftirmeniz gerekiyor, o zaman kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"Sheet1\").Activate<\/code><\/pre><p> Veya sayfa numaralar\u0131n\u0131 da kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"1\").Activate<\/code><\/pre><p> Yani son kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub ActivateSheet1() Worksheets(\"Sheet1\").Activate End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> \u00d6rnekler: VBA ile Elektronik Tabloyu Etkinle\u015ftirme<\/h2><p> Ger\u00e7ek hayatta bu y\u00f6ntemi farkl\u0131 \u015fekillerde kullanabilirsiniz. Burda biraz var.<\/p><h3 class=\"wp-block-heading\"> 1. A\u00e7\u0131ld\u0131\u011f\u0131nda bir e-tabloyu etkinle\u015ftirin<\/h3><p> \u00c7al\u0131\u015fma kitab\u0131n\u0131 her a\u00e7t\u0131\u011f\u0131n\u0131zda belirli bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek istiyorsan\u0131z bu VBA kodunu auto_open olarak adland\u0131r\u0131n.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub auto_open() Worksheets(\"Sheet1\").Activate End Su<\/code><\/pre><h3 class=\"wp-block-heading\"> 2. Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirin ve di\u011ferlerini gizleyin<\/h3><p> Belki bir \u00e7al\u0131\u015fma sayfas\u0131na gidip \u00e7al\u0131\u015fma kitab\u0131ndaki di\u011fer t\u00fcm \u00e7al\u0131\u015fma sayfalar\u0131n\u0131 gizlemek isteyebilirsiniz. A\u015fa\u011f\u0131daki kodu kullanarak bunu yapabilirsiniz.<\/p><pre class=\"wp-block-code\" title=\"Coded\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub HideWorksheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name &lt;&gt; \"Sheet1\" Then ws.Visible = xlSheetHidden End If Next ws End Sub<\/code><\/pre><p> Daha kullan\u0131\u015fl\u0131 hale getirmek i\u00e7in sayfa ad\u0131n\u0131 yukar\u0131daki koddan de\u011fi\u015ftirin.<\/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\/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><\/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-2161","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 sayfa nas\u0131l etkinle\u015ftirilir? (Y\u00f6ntem 2023)<\/title>\n<meta name=\"description\" content=\"Bu durumda herhangi bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in VBA kodunu kullanabilirsiniz. Ve VBA kodunu yazmak i\u00e7in\" \/>\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\/sayfayi-etkinlestir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir? (Y\u00f6ntem 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu durumda herhangi bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in VBA kodunu kullanabilirsiniz. Ve VBA kodunu yazmak i\u00e7in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:06:20+00:00\" \/>\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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\",\"name\":\"VBA kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir? (Y\u00f6ntem 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"datePublished\":\"2023-09-27T15:58:58+00:00\",\"dateModified\":\"2023-12-10T06:06:20+00:00\",\"description\":\"Bu durumda herhangi bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in VBA kodunu kullanabilirsiniz. Ve VBA kodunu yazmak i\u00e7in\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir?\"}]},{\"@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 sayfa nas\u0131l etkinle\u015ftirilir? (Y\u00f6ntem 2023)","description":"Bu durumda herhangi bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in VBA kodunu kullanabilirsiniz. Ve VBA kodunu yazmak i\u00e7in","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\/sayfayi-etkinlestir\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir? (Y\u00f6ntem 2023)","og_description":"Bu durumda herhangi bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in VBA kodunu kullanabilirsiniz. Ve VBA kodunu yazmak i\u00e7in","og_url":"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:06:20+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/","url":"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/","name":"VBA kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir? (Y\u00f6ntem 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"datePublished":"2023-09-27T15:58:58+00:00","dateModified":"2023-12-10T06:06:20+00:00","description":"Bu durumda herhangi bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in VBA kodunu kullanabilirsiniz. Ve VBA kodunu yazmak i\u00e7in","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir?"}]},{"@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\/2161","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=2161"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2161\/revisions"}],"predecessor-version":[{"id":2864,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2161\/revisions\/2864"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}