Jul 21 2020 01:24 PM
Jul 21 2020 01:24 PM
Hi Excel community!
I need some help asap. I have a very important sheet for work that I had put a protected password on over a year ago and I forgot it because I have been furloughed from work and not on the sheet in about 4 months!! I have tried the following code that I found online however my mac just gives me a spinning wheel and doesn't seem to be executing like the way I have seen it online. Someone please help I really need to get back into this sheet otherwise it is going to take me 4+ hours to re-make the sheet!
Sub PasswordBreaker() 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
Nov 05 2022 03:12 PM
Open with Google Sheets. Save as a Google sheets file so it changes it from excel. Open the sheet and enter some random character resave. Open with excel and resave as an excel file password should be gone.
Nov 19 2022 01:53 AM
Nov 19 2022 02:32 AM - edited Nov 19 2022 02:34 AM
If I may add, here are some links that might help you.
I know I don't know anything (Socrates)
Nov 19 2022 01:56 PM
Sorry, you tried on your own protected excel file or the one I attaced of mine to replied?
Nov 19 2022 02:01 PM
Nov 19 2022 03:40 PM
@cery1999 as I said I emailed them to my self and opened on my phone here's some pictures of what to look for. There are three difrent ways on my system to select what program opens them perhaps this is a little above your user level. With a computer it would be right click and open with. Then selecting program *google sheets* you would first have to navigate to the root folder that the document is saved in of course. If that doesn't help I don't really know how to convey to you besides suggesting a YouTube video on opening documents with programs besides the default. 5heres also Linux if that's the case let me know and I can provide instructions I use a different program in linux for this.
Nov 19 2022 03:42 PM
Nov 19 2022 09:31 PM
Nov 20 2022 12:56 AM