{"id":2164,"date":"2023-09-27T15:58:58","date_gmt":"2023-09-27T15:58:58","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/"},"modified":"2023-12-06T06:15:52","modified_gmt":"2023-12-06T06:15:52","slug":"aktifkan-lembar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/","title":{"rendered":"Bagaimana cara mengaktifkan sheet menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-275929742\"><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>Katakanlah Anda bekerja dengan beberapa lembar kerja dan sulit bagi Anda untuk menavigasi ke satu lembar menggunakan tab. Dalam situasi ini, Anda bisa menggunakan kode VBA untuk mengaktifkan lembar kerja apa pun.<\/p><p> Dan, untuk menulis kode VBA untuk ini, Anda perlu menggunakan metode Worksheet.Activate. Pada artikel ini, saya ingin berbagi dengan Anda cara mudah menulis kode ini untuk mengaktifkan atau memilih lembar kerja. Sebelum menulis kode ini, Anda harus memahami cara ini.<\/p><h2 class=\"wp-block-heading\"> Lembar Kerja. Metode Aktifkan<\/h2><p> Pada metode ini, Anda bisa menentukan nama atau nomor lembar kerja yang ingin Anda aktifkan. Misalkan Anda perlu mengaktifkan sheet 1, maka kodenya adalah:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"Sheet1\").Activate<\/code><\/pre><p> Atau bisa juga menggunakan nomor lembar.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"1\").Activate<\/code><\/pre><p> Jadi kode terakhirnya adalah:<\/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\"> Contoh: Aktifkan Spreadsheet dengan VBA<\/h2><p> Dalam kehidupan nyata, Anda dapat menggunakan metode ini dengan berbagai cara. Berikut ini beberapa.<\/p><h3 class=\"wp-block-heading\"> 1. Aktifkan spreadsheet saat dibuka<\/h3><p> Jika Anda ingin mengaktifkan lembar kerja tertentu setiap kali Anda membuka buku kerja, beri nama kode VBA ini auto_open.<\/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. Aktifkan satu lembar kerja dan sembunyikan lembar kerja lainnya<\/h3><p> Mungkin Anda ingin membuka satu lembar kerja dan menyembunyikan semua lembar kerja lainnya di buku kerja. Anda dapat melakukannya menggunakan kode di bawah ini.<\/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> Ubah nama sheet dari kode di atas agar lebih bermanfaat.<\/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\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/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\/id\/lembar-bening\/\">HAPUS seluruh lembar menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lembar-salinan\/\">Salin dan pindahkan lembar di Excel menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/\">COUNT Lembar menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-lembar-1\/\">HAPUS LEMBAR menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/\">Sembunyikan dan tampilkan lembar menggunakan VBA di Excel<\/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-2164","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>Bagaimana cara mengaktifkan sheet menggunakan VBA? (Metode 2023)<\/title>\n<meta name=\"description\" content=\"Dalam situasi ini, Anda bisa menggunakan kode VBA untuk mengaktifkan lembar kerja apa pun. Dan, untuk menulis kode VBA\" \/>\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\/id\/aktifkan-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengaktifkan sheet menggunakan VBA? (Metode 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam situasi ini, Anda bisa menggunakan kode VBA untuk mengaktifkan lembar kerja apa pun. Dan, untuk menulis kode VBA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:52+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\",\"name\":\"Bagaimana cara mengaktifkan sheet menggunakan VBA? (Metode 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"datePublished\":\"2023-09-27T15:58:58+00:00\",\"dateModified\":\"2023-12-06T06:15:52+00:00\",\"description\":\"Dalam situasi ini, Anda bisa menggunakan kode VBA untuk mengaktifkan lembar kerja apa pun. Dan, untuk menulis kode VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengaktifkan sheet menggunakan vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara mengaktifkan sheet menggunakan VBA? (Metode 2023)","description":"Dalam situasi ini, Anda bisa menggunakan kode VBA untuk mengaktifkan lembar kerja apa pun. Dan, untuk menulis kode VBA","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\/id\/aktifkan-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengaktifkan sheet menggunakan VBA? (Metode 2023)","og_description":"Dalam situasi ini, Anda bisa menggunakan kode VBA untuk mengaktifkan lembar kerja apa pun. Dan, untuk menulis kode VBA","og_url":"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:52+00:00","twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/","url":"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/","name":"Bagaimana cara mengaktifkan sheet menggunakan VBA? (Metode 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"datePublished":"2023-09-27T15:58:58+00:00","dateModified":"2023-12-06T06:15:52+00:00","description":"Dalam situasi ini, Anda bisa menggunakan kode VBA untuk mengaktifkan lembar kerja apa pun. Dan, untuk menulis kode VBA","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengaktifkan sheet menggunakan vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2164"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2164\/revisions"}],"predecessor-version":[{"id":2463,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2164\/revisions\/2463"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}