Tutorial on How to Open a Locked / Protected Excel File

Tutorial on How to Open a Locked / Protected Excel File

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.

Share:

Top Ads

Responsive Ads

Middle Ads 1

Responsive Ads

Middle Ads 2

Responsive Ads

Bottom Ads

Responsive Ads