Excel Worksheet Password Recovery
Current time: 10-18-2018, 06:19 AM
Users browsing this thread: 1 Guest(s)
Author: babog
Last Post: avscorreia
Replies 12
Views 9137

Excel Worksheet Password Recovery
#1
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-----------------
Procedure:
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.

Enjoy
Babo G
_______________________________________
Babo G
The road to success is always under construction
Reply
#2
I have tried out but it does not work. Can others who have tried out and feed back? Thanks!!
Reply
#3
ya i have tried and its working for me..
Y@sir
Reply
#4
99richard
Works perfectly.
Reply
#5
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:

http://forum.civilea.com/thread-27464.html
***************************************


Regards

Dell
[-] 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
Reply
#6
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..
Y@sir
Reply
#7
hi

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

regards
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
Reply
#8
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.

:wacko2:
Reply
#9
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
Reply
#10
code works perfectly

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


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



Users browsing this thread: 1 Guest(s)