Ikuti langkah-langkah berikut :
1. Buka file Excel yang akan di unprotect
2. Lalu tekan Alt + F11 maka akan tampil seperti berikut :
3. Kemudian tekan F5 lalu buat nama macros sesuai keinginan anda....misalkan ketik nama Unprotect kemudian pilih Create....
4. hapus script di bawah ini....
5. Copy-pastekan kode di bawah ini lalu tekan F5......
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
6. tunggu sampai keluar dialog seperti di bawah,,,,,,,,,,,,,,jika sudah berarti file Excel sudah di unprotect..
akan tetapi jika file yang terprotect adalah VBA Projectnya maka langkah ini belum bisa di pakai. ....
No comments:
Post a Comment