{"id":1574,"date":"2023-11-16T13:19:07","date_gmt":"2023-11-16T13:19:07","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/"},"modified":"2023-12-06T06:19:06","modified_gmt":"2023-12-06T06:19:06","slug":"lembar-sembunyikan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/","title":{"rendered":"Bagaimana cara menyembunyikan\/menampilkan lembar menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3112555383\"><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>Anda dapat menggunakan kode VBA untuk menyembunyikan atau memperlihatkan lembar di Excel. Saat Anda mengklik kanan pada tab lembar, Anda dapat melihat opsi untuk menyembunyikan atau menampilkannya, dan hal yang sama dapat Anda lakukan dengan kode VBA.<\/p><p> Pada artikel ini kita akan melihat beberapa cara dan metode yang dapat kita gunakan.<\/p><h2 class=\"wp-block-heading\"> Kode VBA untuk menyembunyikan sheet<\/h2><p> Katakanlah Anda ingin menyembunyikan &#8220;Sheet1&#8221; dari buku kerja yang aktif. Dalam hal ini Anda harus menggunakan kode seperti ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(\"Sheet1\").Visible = False<\/code><\/pre><p> Pada kode di atas, Anda mereferensikan Sheet1, menggunakan properti terlihat dan mengubahnya menjadi false.<\/p><h2 class=\"wp-block-heading\"> Buat daunnya sangat tersembunyi<\/h2><p> Ada opsi lain yang dapat Anda gunakan untuk membuat lembar yang sangat tersembunyi yang tidak dapat disembunyikan dengan mudah oleh pengguna.<\/p><h2 class=\"wp-block-heading\"> Sembunyikan lembar berdasarkan nilai sel<\/h2><p> Oke, jika Anda ingin menggunakan nilai sel daripada langsung menggunakan nama sheet di kode, Anda bisa merujuk ke sel ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(Range(\"A1\").Value).Visible = True<\/code><\/pre><p> Kode ini mereferensikan sel A1 dan menggunakan nilai di sana untuk merujuk ke lembar yang ingin Anda sembunyikan.<\/p><p class=\"content-box-grey\"> <em>Tautan yang berguna: <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/merekam-makro\/\">Perekam makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">Editor Visual Basic<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/buku-catatan-makro-pribadi\/\">Buku Pegangan Makro Pribadi<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Periksa lembar itu sebelum menyembunyikannya<\/h2><p> Anda juga dapat menggunakan kode kecil seperti ini untuk memeriksa sheet yang outputnya ingin Anda sembunyikan atau tidak.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_hide_sheet() Dim sht As Worksheet For Each sht In ThisWorkbook.Worksheets If sht.Name = \"Sheet1\" Then sht.Visible = False Exit Sub End If Next sht MsgBox \"Sheet not found\", vbCritical, \"Error\" End Sub<\/code><\/pre><p> Kode di atas menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">FOR EACH LOOP<\/a> + <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">IF STATEMENT<\/a> untuk mengulang setiap lembar di buku kerja. Dan centang lembar yang ingin Anda sembunyikan.<\/p><h2 class=\"wp-block-heading\"> Sembunyikan semua sheet (kecuali ActiveSheet)<\/h2><p> Sekarang ada satu hal yang perlu Anda pahami, Anda tidak bisa menyembunyikan semua daunnya. Harus ada satu daun yang terlihat sepanjang waktu.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_hide_sheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Sheets If ActiveSheet.Name &lt;&gt; ws.Name Then ws.Visible = False End If Next ws End Sub<\/code><\/pre><p> Kode di atas mengulangi seluruh lembar di buku kerja, lalu mencocokkan nama setiap lembar dengan nama lembar aktif dan menyembunyikannya jika tidak cocok.<\/p><h2 class=\"wp-block-heading\"> Kode VBA untuk menampilkan sheet<\/h2><p> Untuk menampilkan sheet, Anda harus mengubah properti terlihat menjadi TRUE.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(\"Sheet1\").Visible = False<\/code><\/pre><p> Jika sheet yang ingin Anda tampilkan sudah terlihat, kode ini tidak akan menampilkan kesalahan apa pun. Namun jika sheet ini tidak ada, Anda akan mendapatkan error runtime &#8216;9&#8217;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52343\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"kode-vba-untuk-memperlihatkan-lembar\" width=\"380\" height=\"214\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan VBA untuk menampilkan semua lembar tersembunyi<\/h2><p> Bayangkan Anda memiliki beberapa lembar tersembunyi di buku kerja dan jika Anda ingin menyembunyikannya secara manual, Anda harus melakukannya satu per satu.<\/p><p> Tapi ini kode yang melakukan ini sekaligus.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_unhide_sheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Sheets If ws.Visible = False Then ws.Visible = True End If Next ws End Sub<\/code><\/pre><p> Dia memeriksa setiap daun dan membuka kedoknya.<\/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\/melindungi-daunnya\/\">PROTECT dan UNPROTECT sheet menggunakan VBA di Excel<\/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-1574","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>\u25b7 Bagaimana cara menyembunyikan\/menampilkan sheet menggunakan VBA?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan cara menyembunyikan dan menampilkan lembar kerja menggunakan kode VBA. Ini juga menunjukkan Anda berbeda\" \/>\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\/lembar-sembunyikan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menyembunyikan\/menampilkan sheet menggunakan VBA?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan cara menyembunyikan dan menampilkan lembar kerja menggunakan kode VBA. Ini juga menunjukkan Anda berbeda\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png\" \/>\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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/\",\"name\":\"\u25b7 Bagaimana cara menyembunyikan\/menampilkan sheet menggunakan VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png\",\"datePublished\":\"2023-11-16T13:19:07+00:00\",\"dateModified\":\"2023-12-06T06:19:06+00:00\",\"description\":\"Tutorial ini menunjukkan cara menyembunyikan dan menampilkan lembar kerja menggunakan kode VBA. Ini juga menunjukkan Anda berbeda\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyembunyikan\/menampilkan lembar 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":"\u25b7 Bagaimana cara menyembunyikan\/menampilkan sheet menggunakan VBA?","description":"Tutorial ini menunjukkan cara menyembunyikan dan menampilkan lembar kerja menggunakan kode VBA. Ini juga menunjukkan Anda berbeda","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\/lembar-sembunyikan\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menyembunyikan\/menampilkan sheet menggunakan VBA?","og_description":"Tutorial ini menunjukkan cara menyembunyikan dan menampilkan lembar kerja menggunakan kode VBA. Ini juga menunjukkan Anda berbeda","og_url":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:06+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/","url":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/","name":"\u25b7 Bagaimana cara menyembunyikan\/menampilkan sheet menggunakan VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png","datePublished":"2023-11-16T13:19:07+00:00","dateModified":"2023-12-06T06:19:06+00:00","description":"Tutorial ini menunjukkan cara menyembunyikan dan menampilkan lembar kerja menggunakan kode VBA. Ini juga menunjukkan Anda berbeda","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-vba-pour-afficher-une-feuille.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyembunyikan\/menampilkan lembar 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\/1574","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=1574"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1574\/revisions"}],"predecessor-version":[{"id":2809,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1574\/revisions\/2809"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}