• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unable to Break Password in Protected sheet on - MS 365


We were using the below code to break password in protected sheet but the same is not working in MS 365 Excel can suggest any idea how to break password in protect sheet in MS 365.

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

the person who created file has left the company, before he left didn't share the password with anyone, now i need to do some changes. and i not able to insert new sheet too, that is the problem.
Cannot You ask it from the person?

Now, You're asking to insert new sheet
... but You've asked how to able to do something with sheet which is already in that file.
Those are different cases.
I didn't know this forum provided help for breaking passwords ?
The other forums I work on certainly don't :(
I had the same problem somewere in 2015, post your file and I can see what I can do, no promices.
Shouldn't it already be common sense to understand that breaking password is not right?
Why have you still in the above topics, like The vault or whatever solutions for these questions?


For me, this almost goes to same category like those over 2500 IPs, which I've blocked - because someone has written spam.
... for spams, there are written rules.