Assalamualaikum..master2 excel, khususnya abang caton yg terus mengawal forum ini
saya ingin tanya masalah VBA tentang "memunculkan password sheet yg lupa" krena password sheet yg dibuat lupa.
dari searching di gogle sya menemukan VBA yg bisa membuat password yg lupa jadi muncul tapi pas di eksekusi ada error di VBA tersebut.dan ini VBA yg saya dapat itu
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 unable 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
mohon petunjuknya dari rumus VBA tersebut kenapa tidak bisa tereksekusi/error
atas jawaban yg diberikan saya sampaikan banyak2 terimakasih