Geekers - As we already know, apart from Microsoft Word, Microsoft Excel is also one of the most widely used software from Microsoft Office to process numbers, one of which is to calculate and record personal or corporate financial data.
Of course, financial data must be confidential and not just anyone is allowed to see it. One way to secure Excel files so that they cannot be opened or edited by others is to use the password protection feature.
So the question is, how do you unlock a password-protected Excel file? when trying to click on one of the cells on the protected sheet a warning message appears "The cell or chart you are trying to change is on protected sheet".
How to Open a Locked Excel File
Microsoft Excel is a worksheet or spreadsheet processing software program distributed and developed by the Microsoft company. Microsoft Excel software can be run on Microsoft Windows and MacOS operating systems.
Microsoft Excel is also available for iOS and Android versions. The development of Microsoft Excel cannot be separated from the history of Microsoft Windows. Here's how to open a locked or protected Excel file.
1. Open the excel file that you want to open and edit.
2. If your excel file is protected, a warning will appear with the words "The cell or chart you are trying to change is on protected sheet". Then click Ok, see the example in the picture. How to Open a Locked Excel File How to Open a Locked Excel File
3. Then press ALT + F11 on the keyboard.
4. Then Microsoft Visual Basic will appear, then you click the Insert menu then select Module. See an example in the picture. Microsoft Visual Basic Microsoft Visual Basic
5. Then the form module will appear, in the form module enter the following code.
InternalPasswords() sub
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveWorkbook.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
& Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
& Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveWorkbook.ProtectStructure = False Then
If ActiveWorkbook.ProtectWindows = False Then
If ActiveSheet.ProtectContents = False Then
Exit Sub
End If
End If
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Lihat contoh pada gambar.
masukkan code kedalam form module masukkan code kedalam form module
6. Kemudaian Pilih Sheet yang akan dibuka proteksinya, kemudia klik Ikon Segitga Hijau kemudian klik Run. Lihat contoh pada gambar. Cara Membuka File Excel Yang Terkunci / Proteksi Cara Membuka File Excel Yang Terkunci / Proteksi
Atau kamu juga bisa menekan tombol F5 pada keyboard, dan klin Run.
7. Kemudian tunggu prosesnya hingga selesai agar kode yang telah Anda masukkan bekerja dengan baik.
8. Selesai.
Bagaimana mudah bukan? Untuk membuka protect sheet pada sheet lainnya lakukan langkah-langkah yang sama.
Apabila software excel yang Anda buka menjadi Not Responding pilih tombol Close di pojok kanan atas yang berwarna merah jika muncul dialog pilih Close the program biasanya ini terjadi pada excel versi 2013 hingga versi yang paling baru
Demikianlah langkah-langkah untuk membuka file excel yang terkunci ataupun terpoteksi password. Semoga artikel ini bermanfaat. Selamat mencoba dan Terima Kasih.