{"id":4416,"date":"2023-07-11T06:56:02","date_gmt":"2023-07-11T06:56:02","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/"},"modified":"2023-07-11T06:56:02","modified_gmt":"2023-07-11T06:56:02","slug":"vba-menghapus-lembar-tanpa-peringatan-prompt","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/","title":{"rendered":"Vba: cara menghapus sheet tanpa perintah atau peringatan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Saat Anda menggunakan metode <strong>Hapus<\/strong> di VBA untuk menghapus lembar tertentu di buku kerja, Excel akan mengeluarkan prompt yang menanyakan apakah Anda yakin ingin menghapus lembar tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda bisa menggunakan sintaks berikut di VBA untuk menghapus sheet tanpa prompt atau kotak peringatan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubDeleteSheets<\/span> ()\n\n<span style=\"color: #008000;\">'turn off display alerts\n<\/span>Application.DisplayAlerts = False\n\n<span style=\"color: #008000;\">'delete Sheet1\n<\/span>Sheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \").Delete\n\n<span style=\"color: #008000;\">'turn back on display alerts\n<\/span>Application.DisplayAlerts = True\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini menghapus lembar bernama <strong>Sheet1<\/strong> tanpa perintah atau kotak peringatan apa pun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Baris <strong>Application.DisplayAlerts=False<\/strong> memberitahu VBA untuk mematikan semua peringatan tampilan di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian menggunakan metode <strong>Hapus<\/strong> untuk menghapus lembar tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian menggunakan <strong>Application.DisplayAlerts=True<\/strong> untuk mengaktifkan kembali peringatan tampilan.<\/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: Gunakan VBA untuk menghapus sheet tanpa perintah atau peringatan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki buku kerja Excel berikut yang berisi tiga lembar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34618 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ds4.jpg\" alt=\"\" width=\"460\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin membuat makro untuk menghapus sheet bernama <strong>Sheet1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita membuat makro berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubDeleteSheets<\/span> ()\n\n<span style=\"color: #008000;\">'delete Sheet1\n<\/span>Sheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \").Delete\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami akan menerima pesan yang menanyakan apakah kami yakin ingin menghapus sheet ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34617 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ds5.jpg\" alt=\"\" width=\"471\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Namun, kita dapat membuat makro berikut untuk menghapus <strong>Sheet1<\/strong> tanpa perintah apa pun:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubDeleteSheets<\/span> ()\n\n<span style=\"color: #008000;\">'turn off display alerts\n<\/span>Application.DisplayAlerts = False\n\n<span style=\"color: #008000;\">'delete Sheet1\n<\/span>Sheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \").Delete\n\n<span style=\"color: #008000;\">'turn back on display alerts\n<\/span>Application.DisplayAlerts = True\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kita menjalankan makro ini, sheet bernama <strong>Sheet1<\/strong> secara otomatis dihapus dan tidak ada perintah yang muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34619 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ds6.jpg\" alt=\"\" width=\"455\" height=\"365\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Sheet1 telah dihapus sementara dua lembar lainnya tetap utuh.<\/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-menghitung-jumlah-lembar\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah lembar dalam buku kerja<\/a><br \/> VBA: Cara mengekstrak data dari buku kerja lain<br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menyisipkan-banyak-baris\/\" target=\"_blank\" rel=\"noopener\">VBA: cara menyisipkan banyak baris<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Saat Anda menggunakan metode Hapus di VBA untuk menghapus lembar tertentu di buku kerja, Excel akan mengeluarkan prompt yang menanyakan apakah Anda yakin ingin menghapus lembar tersebut. Namun, Anda bisa menggunakan sintaks berikut di VBA untuk menghapus sheet tanpa prompt atau kotak peringatan: SubDeleteSheets () &#8216;turn off display alerts Application.DisplayAlerts = False &#8216;delete Sheet1 Sheets(&#8221; [&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>VBA: Cara menghapus sheet tanpa perintah atau peringatan - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus sheet di buku kerja Excel tanpa mengeluarkan pesan prompt atau peringatan.\" \/>\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-menghapus-lembar-tanpa-peringatan-prompt\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghapus sheet tanpa perintah atau peringatan - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus sheet di buku kerja Excel tanpa mengeluarkan pesan prompt atau peringatan.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T06:56:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ds4.jpg\" \/>\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-menghapus-lembar-tanpa-peringatan-prompt\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/\",\"name\":\"VBA: Cara menghapus sheet tanpa perintah atau peringatan - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T06:56:02+00:00\",\"dateModified\":\"2023-07-11T06:56:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus sheet di buku kerja Excel tanpa mengeluarkan pesan prompt atau peringatan.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghapus sheet tanpa perintah atau peringatan\"}]},{\"@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":"VBA: Cara menghapus sheet tanpa perintah atau peringatan - Statorial","description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus sheet di buku kerja Excel tanpa mengeluarkan pesan prompt atau peringatan.","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-menghapus-lembar-tanpa-peringatan-prompt\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghapus sheet tanpa perintah atau peringatan - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus sheet di buku kerja Excel tanpa mengeluarkan pesan prompt atau peringatan.","og_url":"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/","og_site_name":"Statorials","article_published_time":"2023-07-11T06:56:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ds4.jpg"}],"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-menghapus-lembar-tanpa-peringatan-prompt\/","url":"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/","name":"VBA: Cara menghapus sheet tanpa perintah atau peringatan - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T06:56:02+00:00","dateModified":"2023-07-11T06:56:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus sheet di buku kerja Excel tanpa mengeluarkan pesan prompt atau peringatan.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghapus-lembar-tanpa-peringatan-prompt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghapus sheet tanpa perintah atau peringatan"}]},{"@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\/4416"}],"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=4416"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4416\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}