Skip to Content

Masuk/Daftar

Cara Melindungi Kode VBA

Microsoft Visual Basic for Applications (VBA) adalah bahasa standar untuk menulis program otomasi fungsi di Microsoft Office. Ketahui cara melindungi kode VBA agar program Anda tidak dicuri atau disabotase orang lain.

Metode 1

Metode 1 dari 3:

Melindungi Kode dengan Kata Sandi

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/12\/Protect-VBA-Code-Step-1.jpg\/v4-460px-Protect-VBA-Code-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/12\/Protect-VBA-Code-Step-1.jpg\/v4-728px-Protect-VBA-Code-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

1
Bukalah Visual Basic Editor, yang umumnya berada di menu "Tools" > "Macro" . Jika Anda menggunakan Access, Anda mungkin perlu membuka jendela basis data terlebih dahulu, tergantung pengaturan komputer.
- Pilih "Project Properties" pada menu "Tools" di Visual Basic Editor.
  
  {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/62\/Protect-VBA-Code-Step-1Bullet1.jpg\/v4-460px-Protect-VBA-Code-Step-1Bullet1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/62\/Protect-VBA-Code-Step-1Bullet1.jpg\/v4-728px-Protect-VBA-Code-Step-1Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a7\/Protect-VBA-Code-Step-2.jpg\/v4-460px-Protect-VBA-Code-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Protect-VBA-Code-Step-2.jpg\/v4-728px-Protect-VBA-Code-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b3\/Protect-VBA-Code-Step-3.jpg\/v4-460px-Protect-VBA-Code-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b3\/Protect-VBA-Code-Step-3.jpg\/v4-728px-Protect-VBA-Code-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fc\/Protect-VBA-Code-Step-4.jpg\/v4-460px-Protect-VBA-Code-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fc\/Protect-VBA-Code-Step-4.jpg\/v4-728px-Protect-VBA-Code-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/ba\/Protect-VBA-Code-Step-5.jpg\/v4-460px-Protect-VBA-Code-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/ba\/Protect-VBA-Code-Step-5.jpg\/v4-728px-Protect-VBA-Code-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Jika Anda menggunakan Excel 2007 ke atas, Anda mungkin perlu menyimpan berkas sebagai berkas XLSM agar kode dapat digunakan.)

Iklan

Metode 2

Metode 2 dari 3:

Menyembunyikan Kode VBA dalam Berkas Access 2007 Baca-saja

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8a\/Protect-VBA-Code-Step-6.jpg\/v4-460px-Protect-VBA-Code-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8a\/Protect-VBA-Code-Step-6.jpg\/v4-728px-Protect-VBA-Code-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/76\/Protect-VBA-Code-Step-7.jpg\/v4-460px-Protect-VBA-Code-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/76\/Protect-VBA-Code-Step-7.jpg\/v4-728px-Protect-VBA-Code-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6f\/Protect-VBA-Code-Step-8.jpg\/v4-460px-Protect-VBA-Code-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6f\/Protect-VBA-Code-Step-8.jpg\/v4-728px-Protect-VBA-Code-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bc\/Protect-VBA-Code-Step-9.jpg\/v4-460px-Protect-VBA-Code-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bc\/Protect-VBA-Code-Step-9.jpg\/v4-728px-Protect-VBA-Code-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Berkas ACCDE adalah berkas baca-saja sehingga Anda tetap perlu menyimpan berkas asli untuk membuat perubahan.

Iklan

Metode 3

Metode 3 dari 3:

Melindungi Kode VBA dengan Membuat Add-in

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1c\/Protect-VBA-Code-Step-10.jpg\/v4-460px-Protect-VBA-Code-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1c\/Protect-VBA-Code-Step-10.jpg\/v4-728px-Protect-VBA-Code-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Misalnya, jika kode Anda dirancang untuk Excel, buatlah berkas Excel baru.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/41\/Protect-VBA-Code-Step-11.jpg\/v4-460px-Protect-VBA-Code-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/41\/Protect-VBA-Code-Step-11.jpg\/v4-728px-Protect-VBA-Code-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1b\/Protect-VBA-Code-Step-12.jpg\/v4-460px-Protect-VBA-Code-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1b\/Protect-VBA-Code-Step-12.jpg\/v4-728px-Protect-VBA-Code-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/15\/Protect-VBA-Code-Step-13.jpg\/v4-460px-Protect-VBA-Code-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/15\/Protect-VBA-Code-Step-13.jpg\/v4-728px-Protect-VBA-Code-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6d\/Protect-VBA-Code-Step-14.jpg\/v4-460px-Protect-VBA-Code-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6d\/Protect-VBA-Code-Step-14.jpg\/v4-728px-Protect-VBA-Code-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/69\/Protect-VBA-Code-Step-15.jpg\/v4-460px-Protect-VBA-Code-Step-15.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Protect-VBA-Code-Step-15.jpg\/v4-728px-Protect-VBA-Code-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Untuk menambahkan deskripsi, Anda mungkin perlu mengeklik "Options" pada jendela makro.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/49\/Protect-VBA-Code-Step-16.jpg\/v4-460px-Protect-VBA-Code-Step-16.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/Protect-VBA-Code-Step-16.jpg\/v4-728px-Protect-VBA-Code-Step-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Di Visual Basic Editor, temukan menu "Debug" , dan pilih "Compile VBA Project."
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/41\/Protect-VBA-Code-Step-17.jpg\/v4-460px-Protect-VBA-Code-Step-17.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/41\/Protect-VBA-Code-Step-17.jpg\/v4-728px-Protect-VBA-Code-Step-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c3\/Protect-VBA-Code-Step-18.jpg\/v4-460px-Protect-VBA-Code-Step-18.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Protect-VBA-Code-Step-18.jpg\/v4-728px-Protect-VBA-Code-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b2\/Protect-VBA-Code-Step-19.jpg\/v4-460px-Protect-VBA-Code-Step-19.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b2\/Protect-VBA-Code-Step-19.jpg\/v4-728px-Protect-VBA-Code-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b3\/Protect-VBA-Code-Step-20.jpg\/v4-460px-Protect-VBA-Code-Step-20.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b3\/Protect-VBA-Code-Step-20.jpg\/v4-728px-Protect-VBA-Code-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Anda mungkin perlu mengatur kata sandi, tergantung jenis berkas yang Anda gunakan dan pengaturan Office/komputer.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/83\/Protect-VBA-Code-Step-21.jpg\/v4-460px-Protect-VBA-Code-Step-21.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/83\/Protect-VBA-Code-Step-21.jpg\/v4-728px-Protect-VBA-Code-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

atau "Save a Copy" .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Protect-VBA-Code-Step-22.jpg\/v4-460px-Protect-VBA-Code-Step-22.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Protect-VBA-Code-Step-22.jpg\/v4-728px-Protect-VBA-Code-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

13
Akses menu drop-down , kemudian ubah jenis berkas sesuai add-in yang Anda buat.
- Simpan add-in Microsoft Word dalam bentuk DOT atau templat. Jika Anda ingin add-in berjalan saat membuka Word, simpan berkas pada folder "Startup" Word.
- Simpan add-in Microsoft Excel dalam bentuk XLA.
- Simpan add-in Microsoft Access dalam format MDE. Format ini akan melindungi kode VBA. Berkas makro Excel juga dapat disimpan dalam format MDA, tetapi kodenya tidak akan tersembunyi.
- Simpan add-in Microsoft PowerPoint dalam bentuk PPA. Dengan demikian, kode VBA akan terkunci, dan tidak ada orang lain yang dapat mengakses atau menyuntingnya.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/81\/Protect-VBA-Code-Step-23.jpg\/v4-460px-Protect-VBA-Code-Step-23.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Protect-VBA-Code-Step-23.jpg\/v4-728px-Protect-VBA-Code-Step-23.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Add-in Anda akan dapat digunakan.

Iklan

Tips

Jika Anda tidak dapat menemukan VBA Editor atau Add-in Manager, pastikan program terpasang di komputer Anda. Jika program tidak terpasang, Anda mungkin perlu menggunakan CD instalasi Office untuk memasang berkas yang diperlukan.
Pengaturan Microsoft Office Anda mungkin dapat memengaruhi lokasi fungsi di masing-masing program. Jika Anda tidak dapat menemukan fungsi tertentu, carilah fungsi tersebut di menu "Help" .

Iklan

wikiHow Terkait

Iklan

Referensi

Referensi lebih lanjut

Tentang wikiHow ini

wikiHow adalah suatu "wiki", yang berarti ada banyak artikel kami yang disusun oleh lebih dari satu orang. Untuk membuat artikel ini, 12 penyusun, beberapa di antaranya anonim, menyunting dan memperbaiki dari waktu ke waktu. Artikel ini telah dilihat 6.101 kali.

Daftar kategori: Komputer dan Elektronik

Cetak

Halaman ini telah diakses sebanyak 6.101 kali.

Apakah artikel ini membantu Anda?

Iklan

-

-

422

.mwimg a.image{display:none}#header_logo{display:none}#cse-search-box{display:none}#cse-search-box-noscript{display:block !important}#cse-search-box-noscript .cse_q{color:#FFF;background-color:#B3CE9C}.wh_search .cse_q{width:88%}#mw-mf-main-menu-button{display:none;visibility:hidden}.header .search{display:none}#search_footer .cse_sa{background-image:url(/extensions/wikihow/mobile/images/white_mag.png);background-size:22px}.related_box{display:block;background:#EEE;border:5px solid #FFF;vertical-align:bottom;width:127px;background-size:180px;float:left;height:120px;position:relative}.related_box p{line-height:15px !important;font-size:13px;background-color:rgba(67,95,44,.4);color:#FFF;font-weight:bold;padding:8px;margin:0 !important;position:absolute;bottom:0}#noscript_header_logo{display:table-cell;vertical-align:middle;background-position:50% 77%;background-repeat:no-repeat;background-image:url(/extensions/wikihow/mobile/images/wikihow_logo_230.png);background-size:105px;width:auto;height:51px;padding:0 14px}.articleinfo{display:none}#iorg_free_data{z-index:50;width:100%;position:fixed}#ara_recommendations{display:none}

Design a Mobile Website

View Site in Mobile | Classic

Share by: