Bagaimana Cara Unprotect Worksheet Excel yang di Password

Postingan kali ini akan membahas bagaimana cara membuka worksheet yang di protect tanpa memiliki password.

ceritanya ada file workbook yang didalamnya terdapat worksheet yang di password, jika kamu lupa passwordnya atau tidak tahu dan ingin membukannya, ikuti langkah berikut.

  1. Tekan ALT+F11, untuk melihat kode worksheet, klik dua kali sheet yang di protect. (disini Sheet1 yang di protect):
  2. masukan kode dibawah di layar putih tersebut, jangan diganti-ganti hanya copy-paste:

Sub PasswordBreaker()
‘Breaks worksheet password protection.
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
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 ActiveSheet.ProtectContents = False Then
MsgBox “One usable password is ” & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

dan taraaaa…! sekarang sheetnya unprotected dan kamu akan mendapatkan popup password yang bisa digunakan untuk membuka password sheet di workbook yang sama.

sekian, dan DO WITH YOUR OWN RISK!!!

 

 

Sumber :

http://blog.situstarget.com/bagaimana-cara-unprotect-worksheet-excel-yang-di-password/

 

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout /  Ubah )

Foto Google

You are commenting using your Google account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )

Connecting to %s

%d blogger menyukai ini: