{"id":1573,"date":"2023-11-16T13:22:32","date_gmt":"2023-11-16T13:22:32","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/"},"modified":"2023-12-06T06:12:58","modified_gmt":"2023-12-06T06:12:58","slug":"melindungi-buku-kerja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/","title":{"rendered":"Bagaimana cara melindungi buku kerja dengan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2090004274\"><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>Untuk memproteksi buku kerja, Anda harus menggunakan metode PROTECT dari VBA. Dengan menggunakan metode ini, Anda bisa menggunakan kata sandi atau bahkan mengaktifkan perlindungan buku kerja tanpa kata sandi. Namun ada satu hal yang perlu anda perhatikan untuk password yang anda gunakan, yaitu CASE SENSITIF.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbook.Protect \"Password\"<\/code><\/pre><ol type=\"1\"><li> Tentukan buku kerja yang ingin Anda proteksi.<\/li><li> Ketuk dan arahkan dan pilih metode perlindungan dari daftar atau Anda dapat mengetuk \u201cLindungi\u201d.<\/li><li> Masukkan kata sandi yang ingin Anda atur.<\/li><li> Jalankan kode untuk melindungi buku kerja.<\/li><\/ol><p> Dalam tutorial ini, kita akan mempelajari metode ini dengan berbagai cara dan juga mempelajari cara membuka proteksi buku kerja.<\/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\"> Lindungi buku kerja dengan kata sandi<\/h2><p> Di bawah ini adalah kode yang perlu Anda gunakan untuk melindungi buku kerja dengan kata sandi. Dalam kode ini, pertama-tama Anda memiliki nama buku kerja dan metode proteksi kata sandi.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"Book1\").Protect \"test123\"<\/code><\/pre><p> Dan ketika saya menjalankan kode ini, itu mengunci buku kerja &#8220;Book1&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53290\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png\" sizes=\"auto, \" srcset=\"\" alt=\"itu mengunci folder book1\" width=\"703\" height=\"282\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Lindungi buku kerja tanpa kata sandi<\/h3><p> Dan jika Anda ingin memproteksi buku kerja tanpa kata sandi, sebaiknya abaikan argumen &#8220;Kata Sandi&#8221;, seperti kode berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"Book1\").Protect<\/code><\/pre><p> Jika Anda mencoba memproteksi buku kerja tanpa kata sandi yang sudah dilindungi kata sandi, Excel akan menampilkan kotak dialog untuk memasukkan kata sandi tersebut.<\/p><h2 class=\"wp-block-heading\"> Buka proteksi buku kerja dengan kata sandi<\/h2><p> Dengan cara yang sama, Anda bisa menggunakan metode unprotect untuk membuka proteksi buku kerja dan kodenya akan terlihat seperti di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"Book1\").Unprotect \"test123\"<\/code><\/pre><p> Ada satu hal yang perlu Anda perhatikan jika Anda mencoba membuka proteksi buku kerja yaitu w<\/p><h3 class=\"wp-block-heading\"> Buka proteksi buku kerja tanpa kata sandi<\/h3><p> Dan jika buku kerja diproteksi tanpa kata sandi, Anda bisa menggunakan metode yang sama tanpa menentukan argumen kata sandi.<\/p><h2 class=\"wp-block-heading\"> Lindungi semua buku kerja yang terbuka<\/h2><p> Pada kode di bawah ini, kita memiliki <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">perulangan FOR EACH<\/a> untuk mengulang semua buku kerja yang terbuka dan memproteksi setiap buku kerja satu per satu menggunakan metode perlindungan yang sama.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">'variable to use as a workbook Dim wb As Workbook 'loop through all the open workbooks For Each wb In Application.Workbooks 'condition to check workbook name If wb.Name &lt;&gt; \"PERSONAL.XLSB\" Then 'protect every workbook with a password wb.Protect \"test123\" End If Next wb End Sub<\/code><\/pre><p> Karena saya menggunakan buku kerja makro pribadi, saya menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">pernyataan IF THEN ELSE<\/a> untuk mengabaikan jika nama buku kerja adalah &#8221; <a href=\"https:\/\/exceladvisor.org\/id\/buku-catatan-makro-pribadi\/\">personal.xlsb<\/a> &#8220;. Pastikan juga Anda menjaganya.<\/p><h2 class=\"wp-block-heading\"> Lindungi buku kerja yang tertutup<\/h2><p> Anda juga dapat memproteksi dan membuka proteksi buku kerja tertutup yang disimpan ke suatu lokasi. Lihatlah kode berikut di mana saya menggunakan lokasi desktop saya untuk menggunakan file \u201ctest.xlsx\u201d.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_protect_workbook() 'declare varibale to use for the workbook Dim wb As Workbook 'open the workbook that you want to protect Set wb = Workbooks.Open(\"C:UsersDellDesktoptest.xlsx\") 'turn off the screen-updating to _ done everything in the backend Application.ScreenUpdating = False 'protect the workbook wb.Protect 'close the workbook after protecting wb.Close SaveChanges = True 'turn off the screen-updating Application.ScreenUpdating = True End Sub<\/code><\/pre><p> Kode di atas menggunakan metode Workbook.Open untuk membuka buku kerja yang ingin Anda lindungi, lalu nonaktifkan pembaruan layar agar berfungsi di backend.<\/p><h2 class=\"wp-block-heading\"> Lindungi semua buku kerja yang tertutup dalam satu folder<\/h2><p> Kode berikut mengulangi semua buku kerja yang ada di folder yang Anda tentukan sebagai jalurnya. Lalu buka setiap binder, lindungi dan tutup satu per satu.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_protect_all_the_workbooks() 'declare variables Dim wb As Workbook Dim myPath As String Dim myFile As String Dim myExtension As String Dim FldrPicker As FileDialog 'optimize macro Application.ScreenUpdating = False Application.EnableEvents = False Application.Calculation = xlCalculationManual 'specify the folder where workbooks are saved myPath = \"C:UsersDellDesktopfolder\" 'jump to reset setting if there's an error On Error GoTo ResetSettings 'target file fxtension (must include wildcard \"*\") myExtension = \"*.xls*\" 'target path myFile = Dir(myPath &amp; myExtension) 'Loop through each Excel file in folder Do While myFile &lt;&gt; \"\" 'Set variable equal to opened workbook Set wb = Workbooks.Open(Filename:=myPath &amp; myFile) 'protect workbook wb.Protect 'Save and Close Workbook wb.Close SaveChanges:=True 'Get next file name myFile = Dir Loop 'Message Box when task is completed MsgBox \"Done!\" 'reset setting that were change for optimization ResetSettings: Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub<\/code><\/pre><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\/salin-file-excelnya\/\">Salin file Excel (buku kerja) menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\">Buku Kerja Aktifkan VBA (File Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\">Tutup buku kerja VBA (file Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/\">VBA Menggabungkan Buku Kerja (File Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membuat-buku-kerja\/\">VBA Buat buku kerja baru (file 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-1573","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 memproteksi buku kerja menggunakan VBA di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memproteksi dan membuka proteksi buku kerja menggunakan kata sandi. Juga untuk melindungi file atau...\" \/>\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\/melindungi-buku-kerja\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara memproteksi buku kerja menggunakan VBA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memproteksi dan membuka proteksi buku kerja menggunakan kata sandi. Juga untuk melindungi file atau...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.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=\"4 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/\",\"name\":\"\u25b7 Bagaimana cara memproteksi buku kerja menggunakan VBA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png\",\"datePublished\":\"2023-11-16T13:22:32+00:00\",\"dateModified\":\"2023-12-06T06:12:58+00:00\",\"description\":\"Tutorial ini menjelaskan cara memproteksi dan membuka proteksi buku kerja menggunakan kata sandi. Juga untuk melindungi file atau...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara melindungi buku kerja dengan 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 memproteksi buku kerja menggunakan VBA di Excel?","description":"Tutorial ini menjelaskan cara memproteksi dan membuka proteksi buku kerja menggunakan kata sandi. Juga untuk melindungi file atau...","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\/melindungi-buku-kerja\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara memproteksi buku kerja menggunakan VBA di Excel?","og_description":"Tutorial ini menjelaskan cara memproteksi dan membuka proteksi buku kerja menggunakan kata sandi. Juga untuk melindungi file atau...","og_url":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"4 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/","url":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/","name":"\u25b7 Bagaimana cara memproteksi buku kerja menggunakan VBA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png","datePublished":"2023-11-16T13:22:32+00:00","dateModified":"2023-12-06T06:12:58+00:00","description":"Tutorial ini menjelaskan cara memproteksi dan membuka proteksi buku kerja menggunakan kata sandi. Juga untuk melindungi file atau...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-il-verrouille-le-classeur-book1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/melindungi-buku-kerja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara melindungi buku kerja dengan 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\/1573","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=1573"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1573\/revisions"}],"predecessor-version":[{"id":2258,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1573\/revisions\/2258"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}