{"id":4864,"date":"2023-07-07T02:24:38","date_gmt":"2023-07-07T02:24:38","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/"},"modified":"2023-07-07T02:24:38","modified_gmt":"2023-07-07T02:24:38","slug":"vba-tampilkan-semua-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/","title":{"rendered":"Cara menampilkan semua sheet menggunakan vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan properti <strong>Terlihat<\/strong> di VBA untuk menampilkan lembar di buku kerja Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menampilkan semua lembar dalam buku kerja, Anda bisa menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> UnhideAllSheets()\n\n<span style=\"color: #0000ff;\">Dim<\/span> ws <span style=\"color: #0000ff;\">As<\/span> Worksheet\n\n    <span style=\"color: #0000ff;\">For Each<\/span> ws <span style=\"color: #0000ff;\">In<\/span> Worksheets\n        ws.Visible = <span style=\"color: #0000ff;\">True<\/span>\n    <span style=\"color: #0000ff;\">Next<\/span> ws\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Menggunakan loop <strong>For Each<\/strong> sederhana dan menentukan <strong>Visible = True<\/strong> , kami memberi tahu Excel untuk menampilkan semua lembar di buku kerja.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh : Cara menampilkan semua sheet menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki buku kerja Excel dengan empat lembar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37994 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un1.png\" alt=\"\" width=\"471\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita klik kanan <strong>Sheet4<\/strong> lalu klik <strong>Hide<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37995 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un2.png\" alt=\"\" width=\"514\" height=\"373\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ulangi proses ini dengan <strong>Sheet2<\/strong> sehingga satu-satunya sheet yang terlihat sekarang adalah <strong>Sheet1<\/strong> dan <strong>Sheet3<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37996 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un3.png\" alt=\"\" width=\"464\" height=\"375\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menggunakan VBA untuk menampilkan semua lembar di buku kerja.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> UnhideAllSheets()\n\n<span style=\"color: #0000ff;\">Dim<\/span> ws <span style=\"color: #0000ff;\">As<\/span> Worksheet\n\n    <span style=\"color: #0000ff;\">For Each<\/span> ws <span style=\"color: #0000ff;\">In<\/span> Worksheets\n        ws.Visible = <span style=\"color: #0000ff;\">True<\/span>\n    <span style=\"color: #0000ff;\">Next<\/span> ws\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Setelah makro ini dijalankan, semua lembar di buku kerja akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37994 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un1.png\" alt=\"\" width=\"471\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk properti <strong>Visible<\/strong> di VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheet.visible\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-menemukan-baris-terakhir\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menemukan baris yang terakhir digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-temukan-kolom-terakhir\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menemukan kolom yang terakhir digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panel-beku-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara membekukan panel<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan properti Terlihat di VBA untuk menampilkan lembar di buku kerja Excel. Untuk menampilkan semua lembar dalam buku kerja, Anda bisa menggunakan sintaks berikut: Sub UnhideAllSheets() Dim ws As Worksheet For Each ws In Worksheets ws.Visible = True Next ws End Sub Menggunakan loop For Each sederhana dan menentukan Visible = True , [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menampilkan Semua Daun Menggunakan VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menampilkan semua sheet di workbook Excel menggunakan VBA, beserta sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menampilkan Semua Daun Menggunakan VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menampilkan semua sheet di workbook Excel menggunakan VBA, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T02:24:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/\",\"name\":\"Cara Menampilkan Semua Daun Menggunakan VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T02:24:38+00:00\",\"dateModified\":\"2023-07-07T02:24:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menampilkan semua sheet di workbook Excel menggunakan VBA, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menampilkan semua sheet menggunakan vba (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menampilkan Semua Daun Menggunakan VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menampilkan semua sheet di workbook Excel menggunakan VBA, beserta sebuah contoh.","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:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menampilkan Semua Daun Menggunakan VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menampilkan semua sheet di workbook Excel menggunakan VBA, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-07T02:24:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/","url":"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/","name":"Cara Menampilkan Semua Daun Menggunakan VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T02:24:38+00:00","dateModified":"2023-07-07T02:24:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menampilkan semua sheet di workbook Excel menggunakan VBA, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-tampilkan-semua-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menampilkan semua sheet menggunakan vba (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4864"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4864"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4864\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}