Skip to main content

UNPROTECT ANY EXCEL WORKBOOK IN JUST 5 SIMPLE STEPS


The article shows how to unprotect Excel spreadsheet without password if you forgot or misplaced it. 

How to unprotect Excel sheet without password:


If you need to edit a password protected sheet but you cannot remember the password, try to unlock that Excel spreadsheet by using the following method:

Unlock Excel spreadsheet with VBA code (for Excel 2010 and lower)

If you are using Excel 2016 or older version, you can unlock a password-protected sheet with the following macro.
Download the code file from here!

Step 1: Open your Excel document and switch to the password-protected sheet (it should be active when you run the macro).

Step 2: Press Alt + F11 to open the Visual Basic Editor.

Step 3: Right-click the workbook name on the left pane (Project-VBAProject pane) and select Insert > Module from the context menu, or press F7; In the window that appears, paste in the following code:
-------------------------------------------------------------------------------------------------------------
Public Sub AllInternalPasswords()
'Breaks worksheet and workbook structure passwords.
'Bob McCormick probably originator of base code algorithm
'Modified for coverage of workbook structure / windows
'passwords and for multiple passwords
''Reveals passwords NOT "the" passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Dim Mess As String, Header As String
Dim Authors As String, Version As String
Dim RepBack As String, AllClear As String
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Application.ScreenUpdating = True
Header = "Unprotecting"
Version = "Click OK"
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
Mess = "This Workbook Is Password Free"
MsgBox Mess, vbInformation, Header
Exit Sub
End If
MsgBox Mess, vbInformation, Header
If Not WinTag Then
Mess = "This Will Take 2 Minutes" & DBLSPACE & _
"Proceeding to unprotect sheets." & DBLSPACE & _
"Please Wait..." & DBLSPACE & Authors & Version
MsgBox Mess, vbInformation, Header
Else
On Error Resume Next
Do 'dummy do loop
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
With ActiveWorkbook
.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 .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Mess = "You had a Worksheet Structure or " & _
"Windows Password set." & DBLSPACE & _
"The password found was: " & DBLSPACE & _
PWord1 & DBLSPACE & "Note it down for " & _
"potential future use in other " & _
"workbooks by same person who set this " & _
"password." & DBLSPACE & _
"Now to check and clear other passwords." & _
Authors & Version
MsgBox Mess, vbInformation, Header
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
Mess = "Only structure / windows protected with " & _
"the password that was just found." & _
AllClear & Authors & Version & RepBack
MsgBox Mess, vbInformation, Header
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag Then
Mess = AllClear & Authors & Version & RepBack
MsgBox Mess, vbInformation, Header
Exit Sub
End If
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
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
.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 Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Mess, vbInformation, Header
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
Mess = AllClear & Authors & Version & RepBack
MsgBox Mess, vbInformation, Header
End Sub

-------------------------------------------------------------------------------------------------------------
Step 4: Press F5 or click the Run button

Step 5: Now, a popup massage will appear on the screen click “OK” 3 times and wait 2 minutes; and Your Excel Sheet is Password Free.
Download the code file from here!

Know about us - https://thetaxsupport.com
You can find more articles on at https://thetaxsupport.com/blog
You can find tutorial videos on at https://www.youtube.com/c/vipinsanger
Labels:
Location: New Delhi, Delhi, India

Comments

Post a Comment

Popular posts from this blog

4 Quick Tips to Stop Overspending..!!

The Tax Support Y ou may are during a situation where you've planned to save lots of money rather than overspending it. you'll have planned to shop for only what's necessary, stop eating out and control the urge to online shopping. Unfortunately, at the top of the month, you've ended up spending quite what you've thought you'd. Stopping overspending isn't as easy because it seems to be and if you actually want to save lots of money, read on to understand four quick and straightforward tips and tricks. Why shouldn't you overspend? In spite of the very fact that overspending may be a 'subjective' term, most folks tend to spend quite what we should always. Though it's going to not be easy to believe that you're overspending, the sooner you realize the very fact , the better it gets in controlling your urge to spend more. If you're one among those that purchase items because they're hooked in to those, ask yourself whether ...
Post a Comment
Read more

Here's All You Need To Know About Indian Digital Tax

The Covid-19 outbreak has compelled businesses to transcend from traditional to digital models of work. With business models evolving on account of mass digitization, the complexities from a regulatory and taxation standpoint have only amplified. The advent and access to technology have enabled businesses to carry on business-as-usual with minimal physical presence. Unsurprisingly, India has the second-largest online users in the world, with over 560 million internet users, and hence, from the viewpoint of its tax revenue base, digital businesses could not be overlooked. However, as is the case in other jurisdictions, Indian tax laws were suited for conventional business models such as brick and mortar stores and thus in dire need of an overhaul. Recent Amendments To ensure that value created digitally is appropriately taxed; two significant amendments were introduced in Indian taxation laws in the recent past – The “Equalization Levy” – a tax aimed at foreign digital...
Post a Comment
Read more

ITR Due Dates may extend till September 2020

The government is considering a proposal to extend the deadline for filing personal income tax returns to September 30 from July 31 because of the lockdown. The last date for paying advance tax has already been extended till June 30 from March 31. A senior finance ministry official said the CBDT was considering an extension of the last date to file personal income tax returns to September 30 from July 31. Besides the date for advance tax, the government has extended the deadline for employers to issue TDS certificates, or Form 16, to June 30. Tax practioners said it would be difficult for employees to file their income tax returns by July 31 — the normal deadline for most individuals to file ITRs — if they get their Form -16 (TDS certificates) as late as June 30. So, it is likely that the deadline of July 31 to file ITRs would also be extended. According to the income tax laws, the last date for filing TDS returns for an employer is May 31 and Form 16 has to b...
Post a Comment
Read more