Dikutip dari Makeusof, berikut ini adalah cara untuk membuat password di Excel agar tak sembarang orang bisa membukanya: Buka file Excel yang datanya ingin Anda lindungi selanjutnya klik File > Info > Protect Workbook >Encrypt with Password. Masukkan kata sandi yang diinginkan dan klik “OK”. Konfirmasi password yang dibuat. To reset your settings. First, open MS Excel or MS Word. Second, click on Options in the bottom-left corner. Options. Click on Trust Center. Then, click on Trust Center Settings. Click on Trust Center Settings. Lastly, under Protected View make sure that the following options are checked. How to Remove Password Protection For Excel Workbook [Tutorial]This tutorial shows how to remove password from Excel file using multiple methods. Some method First, we would see a simple example to unprotect the sheet. For this, follow the steps below: Step 1: First open a module from the Insert menu tab as shown below. Step 2: Now write the subprocedure of the VBA Unprotect sheet. Or we can choose any other name to define it. Code: Sub VBA_Unprotect () End Sub. .

cara membuka protect workbook excel