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
Dec 02 2022 06:26 AM
Dec 11 2022 02:47 AM
I was trying to access a password protected spreadsheet.
I read through various replies here and came up with a very simple solution that worked for me.
- Save the protected Excel file as 97-2003
- Open in Google Drive
- Sheet is unprotected
the spreadsheet in question can be found here:
Search: Private sector rents. Information on monthly rents paid in the private rented sector in Wales.Data Provider: Welsh Government Private sector rents by local authority, 1 January to 31 December 2019
Dec 11 2022 08:48 PM
On your fist step, how to save the protected excel file to version 97-2003? I can't open the protected excel, it is blank screen, only a box that I need to enter a password. Using rename function?
Dec 29 2022 11:54 AM
Removed the underscore and extra spaces between the next line
.Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(n) & Chr(o) & Chr(p) & Chr(q) & Chr(r) & Chr(s) & Chr(t)
Dec 29 2022 11:55 AM
Jan 26 2023 04:56 AM
Hello I did some modifications ( getting log file) in hope that the password will be retrieved but alas it ain't working. Please have a look at it if I'm missing something
Option Explicit
Sub GetPass()
Const a = 65, b = 66, c = 32, d = 126
Dim i#, j#, k#, l#, m#, n#, o#, p#, q#, r#, s#, t#
Dim logPath As String
logPath = "C:\logs\password_attempts.txt"
With ActiveSheet
If .ProtectContents Then
On Error Resume Next
For i = a To b
For j = a To b
For k = a To b
For l = a To b
For m = a To b
For n = a To b
For o = a To b
For p = a To b
For q = a To b
For r = a To b
For s = a To b
For t = c To d
Open logPath For Append As #1
Print #1, Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(n) & Chr(o) & Chr(p) & Chr(q) & Chr(r) & Chr(s) & Chr(t)
Close #1
.Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & _
Chr(n) & Chr(o) & Chr(p) & Chr(q) & Chr(r) & Chr(s) & Chr(t)
Next t
Next s
Next r
Next q
Next p
Next o
Next n
Next m
Next l
Next k
Next j
Next i
MsgBox "Finished"
End If
End With
End Sub
Jan 26 2023 06:25 AM
Jan 26 2023 06:44 AM
I know that, but my issue is that the password for unlocking is not getting shown in log file
Jan 26 2023 09:23 AM
@NikolinoDE I have ran the macro, but when I open the new file it is blank. Is it possible since my file of from 2017 there is a problem with my excel version?
Jan 31 2023 01:18 PM
Please can you help me how to unprotect my excel spreadsheet? I forgot the password. I tried with the codes you suggested. But it couldn't perform. Shall I send you the spreadsheet and will you unprotect it please?
Feb 05 2023 01:29 PM
Feb 06 2023 08:08 AM
Feb 22 2023 03:14 AM
Hello @NikolinoDE
I am a new user, and don't know how to send a file, please advise oh sharing the file
Feb 22 2023 10:20 AM
I ran the code you specified to remove the password and got the message box stating "Finished". However, the password still remains on the worksheet and the message box never told me what the password was. Any suggestions?
Feb 24 2023 07:32 PM
Mar 07 2023 06:07 AM
Mar 11 2023 05:26 PM
@vedangbapna it's easy, you can try catpasswd.com online recovery forgot password
Mar 13 2023 05:25 AM
I never could get this to work. I found the same solution that others have found and it worked perfectly for me. Here are the instructions that I typed up for it:
Removing worksheet protection from Excel files
Mar 13 2023 06:03 AM
You can also find these instructions as a description in these links. As for the code, all I can say is that it has always worked for me...when it comes to worksheets.