Jump to content
Sign in to follow this  
Faris

Cara BOBOL PASSWORD sheet ms. excel yang di password

Recommended Posts

Bagi teman2 yang ada masalah dengan password unprotected sheet. ms. excel ( yg udah dicoba ms.excel 2007) mungkin lupa password atau apalah, berikut ini ada cara untuk mendapatkan passwordnya :

  1. buka file yang mau di unprotect passwordnya
  2. tekan Alt + F11
  3. pilih menu insert – module
  4. langsung masukkan script berikut

Sub PasswordBreaker()’Breaks worksheet password protection.Dim i As Integer, j As Integer, k As IntegerDim l As Integer, m As Integer, n As IntegerDim i1 As Integer, i2 As Integer, i3 As IntegerDim i4 As Integer, i5 As Integer, i6 As IntegerOn Error Resume NextFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ActiveSheet.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 ThenMsgBox “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 SubEnd IfNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextEnd Sub

  1. 5. tutup menu vba nya dengan meng klik tombol X pojok kanan monitor 

6. setelah itu muncul ms. excel lalu pilih menu view -> macros ->view macros->run

7. tunggu hingga keluar passwordnya,( atau bisa juga lihat password di kolom A1)

Gunakanlah dengan bijak, jangan di pakai untuk merugikan diri sendiri apalagi merugikan orang lain.

OK. sekian dulu slamat mencoba

 

Sumber : siberkolosis.com

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  



×