Aug 08 2020 04:10 AM - last edited on Nov 09 2023 11:08 AM by
Hi team need support to unprotect my sheet which is password protected and forgot the password
Mar 16 2023 05:51 PM
where can I send the workbook for you to unprotect it?
Apr 07 2023 06:09 AM
Amazingly its worked very smart. I've another workbook that does not have macro enable file. but it have password and how this code work on that file. Because there is no module insert option. @NikolinoDE
Apr 13 2023 12:48 PM - edited Apr 13 2023 12:58 PM
Having some real problems with getting this to work. Deleted all the extra spaces and it would at least start with the spinning thing but it never finishes. Made a very small two sheet Excel file with very little info and password protected it (as a test). Opened up VBA, selected sheet 1 and copied the code into the window. What should the two drop down windows at the top be set at? They default to "(General)" and "GetPass". And "Option Explicit" is above a line at the top- is that OK? I feel like a tiny file like my test one should un-protect in no time but maybe I'm wrong.
Apr 13 2023 01:21 PM
Apr 13 2023 06:30 PM
Here is the link that explains it in detail: Password options
Step by step what we need to do to unlock it.
Sub OpenSesame()
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 "NikolinoDE: 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
6. Press F5 to run the code.
7. The worksheet will be unlocked.
Here is the link again: Password options
Using a password code remover means you have the proper right to have permission from the Excel file owner to access the protected content and/or unlock the worksheet(s). No one but you is liable for the illegal use of the manual.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Apr 19 2023 10:42 AM
Apr 20 2023 01:19 AM
Apr 20 2023 07:30 AM
Apr 20 2023 09:36 AM
Everything is OK! You have described the steps very nicely.
Just wanted to make it clear, also for the other users, that this is about unlocking worksheets and not files. This is very often confused and many users have read and are reading this message (not only your post :).
Other steps and methods are required to open files, such as brute force, and if the files are Excel 2016 or later, the chances of success are very low.
Here again the note from Microsoft itself: Microsoft informs
I wish you continued success with Microsoft Excel!
I know I don't know anything (Socrates)
May 01 2023 01:00 AM
May 01 2023 01:54 AM
May 30 2023 03:25 PM
I forgot a password to an excel file. So I cannot open the file at all. Is there anyway to remove the password from the file to be able to open it?
May 31 2023 12:49 AM
The answer depends on the version of your file format. If it's a version with a 40-bit encryption key, it can be decrypted without a password. If it's Excel 2003 or later, the only option is to attempt a brute-force search for the correct password. The success of this method depends on the complexity of the password and your knowledge of it (such as using dictionary mutations or positional masks). You can find more details on this topic if you're interested.
Jun 06 2023 07:18 AM
Need to remove the empty line after .Unprotect ...... Compiler looking for code contiunation on next line!
Should be .Unprotect ...........Chr(m) & _
Chr(n)..................
not ...................Chr(m) & _
Chr(n).................................................................
Jun 26 2023 10:19 PM
Jun 26 2023 11:01 PM
Jul 07 2023 11:50 AM
Hi! can ou please help with this file? the tab is 2023 locked worksheet. Is it possible to find out what password was?
Jul 09 2023 08:16 AM
hello, sir I read your comment on how to unlock your Excel workbook but I could not do that. sir, I want your help could you please unlock my Excel workbook? I need your email so that I send you my Excel sheet. I hope you will help me.
Jul 12 2023 01:04 PM
Jul 18 2023 08:48 PM
Hi, thank you for being so helpful in the forum. I have used the same password for a number of iterations of my personal excel sheet. And now it has stopped working. I have used the same password for 4 years, so I really doubt that I am typing in the wrong password.
I have seen your helpful code promts but I am not technical enough to repeat these processes. Any thoughts what I can do. Would prefer not to send the password out if possible. :(