How to Unprotect Excel without Password

bardimin pic

Bardimin

February 22, 2022
unprotect-sheet-excel-01

How to Unprotect Excel without Password

Home » Blogs » Software » How to Unprotect Excel without Password

When you work with Microsoft Excel, you can protect the documents you create by using a password.

There are two ways to protect your file with a password. First, you can protect the file by every time you open the file, excel will ask for the password you created. Second, you can protect it by preventing other people from changing your excel file. It can only make changes when protection has been disabled using the password you created.

Protection secondly can be applied to the “Sheet” or “Workbook” in the excel file. You can set this method to prohibit changes to part or all of the documents that you create.

What if you forget the password you have created?

You cannot change an excel file that has been protected in the “Sheet” or “Workbook” without knowing the password. You can only see without being able to make changes.

But you don't have to worry, Bardimin will share how to open excel protection without using a password.

How to unprotect Excel “Sheet” in Microsoft Excel 2010 and below

In 2010 and below, if you forget the password protection, you can open the protection by using VBA.

  1. Open your excel file with .
  2. Press ( Alt + F11 ) to open the Editor.
  3. After the Editor window opens, then click “ ThisWorkbook > Insert > Module ”.
unprotect-sheet-excel-01
  1. Then type the following VBA code in the window that appears.
Sub PasswordBreaker()
	'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 "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

Source: ablebits.com

  1. Then return to the Ms. window. Excel and select the “ Sheet ” you want to unprotect . Then run the by pressing ( Alt + F8 ) to open the macro window and then select the macro ” PasswordBreaker ” and click the ” Run ” button .
unprotect-sheet-excel-02

The VBA Macro only works on the Active Sheet

  1. Wait until the process is complete, if successful you will see a window like the following
unprotect-sheet-excel-03

How to unprotect Excel “Sheet” in Microsoft Excel 2013 and above

In generations after Microsoft Excel 2010, such as Excel 2013, Excel 2016, Excel 2019, and Excel 2021, you cannot use the VBA Macro to unprotect it. Because the generation of Microsoft Excel has increased its protection system.

To unprotect the “Sheet” in Excel 2013, Excel 2016, Excel 2019, and Excel 2021, you can do the following.

  1. Open your Excel file.
  2. Save As” the file by changing the file type to “Excel 97-2003 Workbook (*. xls )”.
unprotect-sheet-excel-04
  1. Then close the file and reopen the “Save As” Excel file.
  2. Then you can use the Macro VBA script and the steps in the previous example to open a protected “Sheet”.
link nyemin

Latest Articles

How to Create and Save Tab Groups in Google Chrome

How to Create and Save Tab Groups in Google Chrome

Google Chrome is one of the most popular web browsers in the world, with advanced features that make the surfing experience easier and more enjoyable. One feature recently introduced by Google is tab groups, which allow you to group and label the tabs you have opened...

What is a Memory Leak and How to Solve It?

What is a Memory Leak and How to Solve It?

Memory leak is one of the problems often faced by software developers, especially those who use programming languages such as C and C ++. Memory leaks occur when a program allocates memory from a heap but does not free it when it is no longer needed. As a result, the...

How to Create a Strong and Easy-to-Remember Password

How to Create a Strong and Easy-to-Remember Password

A password is the key to accessing your online accounts, be it email, social media, banking, or anything else. A strong and secure password will protect your account from hacker attacks, identity theft, or data misuse. However, strong passwords should also be easy to...

How to Find and Fix Packet Loss on Windows

How to Find and Fix Packet Loss on Windows

Packet loss is a serious problem that can negatively impact various applications and services. It is important to know how to test and fix Packet Loss to ensure that you have a stable and reliable connection. Packet loss is a term used to describe a situation when a...

LACP vs PAgP: What is the Difference and Relationship?

LACP vs PAgP: What is the Difference and Relationship?

LACP (Link Aggregation Control Protocol) and PAgP (Port Aggregation Protocol) are two protocols used to combine multiple physical ports into one logical port, referred to as link aggregation or channel port. The purpose of link aggregation is to increase bandwidth,...