Semua tentang Tekinkom

 

1. Buka file Excel (xls atau xlsx)

2. Arahkan ke sheet yang akan kita bongkar passwordnya

3. Untuk excel 2007 tekan alt+F11 (developer ->visual basic) –> keluar jendela Microsoft visual basic. kemudian pilih insert -> module, kemudian copy-paste kode dibawah ini  ke jendela module

Sub PasswordBreaker()
‘Author unknown but submitted by brettdj of
www.experts-exchange.com
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)
ActiveWorkbook.Sheets(1).Select
Range(“a1″).FormulaR1C1 = 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

4. Save module  kemudian close -> kembali ke work sheet.

5. Pada toolbar excel pilih tab view -> macros -> view macros

6. Pada macro dengan nama PasswordBreaker. klik run dan tunggu beberapa saat.

SELAMAT…password anda telah hilang, sheet menjadi unprotect.

semoga bermanfaat…….

About these ads

Comments on: "Cara Membuka Sheet Excel yang Di-protect" (4)

  1. ada tulisan syntac eror dibagian kalimat pertama, gmn dong?

  2. trankyuuuu :)
    yg error di hapus aj… kalau ngg slah yg tulisan merah

  3. Terima kasih Banyak

  4. kok modulenya tidak aktif juga………gimana caranya membuka

Berikan Balasan

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Awan Tag

Ikuti

Get every new post delivered to your Inbox.

%d blogger menyukai ini: