Open your Excel document and switch to the password-protected sheet. You can do it by clicking on the file icon, it will open a list of options, select the info tab and click on the protect workbook. (it should be active when you run the code). Press Alt + F11 to open the Visual Basic Editor. To protect the structure of your workbook, follow these steps: Click Review > Protect Workbook. Note: The Windows option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. Select the Windows option if you want to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows. To check this, go to the Review tab > Changes group and have a look at the Protect Workbook button. If this button is highlighted in green, the workbook is protected. To unprotect it, click the Protect Workbook button, type the password if prompted and save the workbook. For more information, please see How to unlock a protected workbook in CARA BUKA PROTECT KODE VBA EXCEL. Biasanya untuk melindungi scribe pada vba exel diperlukan password tapi kadang kita lupa pada password yang kita tulis di vba exel dan untuk menampilkan jendela visual basic editor bisa dibuka dengan menekan kombinasi tobol Alt+F11, atau bisa juga dibuka melalui menu developper. Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be edited. To put it simply, the Lock Cell function can only take effect when the Protect Sheet function is turned on. These two functions can only be used together. For Excel files locked for reading, we recommend that you use Excel Password Recovery, which costs only $29.95 and enables you to unlock an unlimited number of Excel files. Unlock both sheets locked for editing and entire Excel workbooks locked for reading. Unlock ALL your Excel files — the program is yours to keep forever! Gunakan perintah “Protect Sheet” untuk melindungi sel yang di-lock tersebut, dengan memilih sebelumnya password yang sama pada opsi “Protect Workbook”. 3. Buat Digital Signature pada File Excel. Jika kerap membuka file Excel yang terdapat informasi penting, membuat digital signature pada file tersebut menjadi solusi yang baik. Open the Excel workbook or sheet you want to protect. Go to the Review tab and click Protect Workbook or Protect Sheet . A Protect Workbook or Protect Sheet window will appear. Follow the below steps to protect the entire file. Step 1: Go to File. Once you click on the Info, you will see the Protect Workbook option on the right side. Step 2: Click on the drop-down list of Protect Workbook option and select Encrypt with Password. Step 3: Enter the password according to your wish and Click OK. Untuk Excel 2010 ataupun versi yang lebih lama, kalian bisa membuka proteksi dokumen Excel dengan menggunakan kode VBA. Pertama, buka dokumen/sheet yang diproteksi pada Ms. Excel. Perlu diketahui, cara ini tidak berlaku pada Ms. Excel 2013 dan versi yang lebih baru. Setelah itu, simpan lagi berkas dengan format .xls. 2mMx.