Excel Worksheet Password Recovery
Current time: 10-24-2021, 07:26 PM
Users browsing this thread: 1 Guest(s)
Author: babog
Last Post: avscorreia
Replies 12
Views 12826

Excel Worksheet Password Recovery
Here is simple routine to recover password for worksheet (not the file password) and unprotect worksheets

-----------------------------------cut below this line------
Sub PasswordBreaker()
'Author unknown
'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
-----------------cut above this line-----------------
start excel
open the excel file you need to unprotect
Start Visual Basic Editor: Tools -> Macro menu -> Visual Basic Editor
Create a new module : Insert -> module
Paste the above code in the module
Close Visual Basic Editor
Run the Macro named "PasswordBreaker" from Tools -> Macro menu
This will give you a password that you can use to unprotect a worksheet
If you have multiple worksheets, you need to run the macro in each worksheet.

Babo G
Babo G
The road to success is always under construction
I have tried out but it does not work. Can others who have tried out and feed back? Thanks!!
ya i have tried and its working for me..
Works perfectly.
Dear All,

another alternative:

Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:



[-] The following 15 users say Thank You to Dell_Brett for this post:
  • vvvv, vvvv, hsccindia, hsccindia, cristi, cristi, libe, libe, vinnunsam, rendel_©, JIGM85, waly76, jcbv, mrjoesan2, adshrt
dear babog
ur subroutine works fine in some worksheets but sometimes it does not break all sheets if there are number of worksheets in a single excel file.. plzz update ur code if u can..

i have used straxx addin for 2 yeras and they solved my problems

the software posted links sould be used for evaluation and testing purposes, if you like it buy it !! Always read the disclaimer and act acoordly
[-] The following 3 users say Thank You to mig21 for this post:
  • Dell_Brett, Yasir, JIGM85
Yasir : You have to run it in every sheet

Dell brett & Mig21 : Could you please provide the "password.xla" file which can be used in Excel 2007 and higher ? Thanks in advance.

When i have a excell worksheet protected whith a pass, first of all i trie to open it whith openoffice, in most cases the "excell" of openoficee breaks all the the pass.

All you have to do is open a xls paper in rhe openoffice, noything else.
[-] The following 2 users say Thank You to cadtfoi for this post:
  • Dell_Brett, mig21
code works perfectly

[-] The following 1 user says Thank You to abhijit for this post:
  • mrjoesan2

Possibly Related Threads…
Thread Author Replies Views Last Post
Excel password bracker aradadi 4 7,243 11-30-2012, 06:55 PM
Last Post: ska51
RC DESIGN WORKSHEET malee 1 5,716 09-22-2012, 09:06 AM
Last Post: adshrt
Rebar Fixing & Anchoring Design Worksheet malee 0 3,656 09-21-2012, 05:48 AM
Last Post: malee

Users browsing this thread: 1 Guest(s)