Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Unprotect Excel Sheet

How to Unprotect Excel Sheet

Bishwo TamliBy Bishwo TamliDecember 14, 2022
how to unprotect excel sheet

Protecting your Excel sheets is a handy feature that stops others from making unwanted changes to your document. There are two ways you can set up a protected excel sheet. You can either use password protection or simple protection only.

In the latter case, you can unprotect the sheets directly in Excel. For password protection, you will need to have the password to unprotect it in Excel. Or, if you’ve forgotten your password, you can use workarounds to access your document.

Table of Contents

  • Unprotect Excel Sheets (As Owner)
  • Unprotect Using Google Sheets
  • Using Macro (Excel 2010 and lower)
  • Use Third-party Applications

Unprotect Excel Sheets (As Owner)

If your protected Excel sheet isn’t password locked or if you have the password, you can unprotect it directly from the sheet itself.

  1. Right-click on Sheet name at the bottom.
    unprotect sheet excel
  2. Select Unprotect sheet. (If the sheet isn’t password locked, it will automatically unprotect when selecting this option.)
  3. Enter your password and press OK.
    unprotect sheet enter password excel]

Unprotect Using Google Sheets

If you don’t have the password for unprotecting Excel sheets, you can still access your document through Google Sheets as a workaround.

  1. Navigate to the folder containing your password-protected excel sheets.
    microsoft excel worksheets
  2. Open Google Drive in your browser.
  3. Drag and drop the password-protected sheet file to your drive.
    uploaded xlsx file to drive
  4. After the upload finishes, double-click on the file to open it.
  5. Press the Ctrl + Space + A button to select all and Ctrl + C to copy.
    copy google sheets contents
  6. Click on the file at the top right and choose New.
    google sheets file new spreadsheet
  7. Select Spreadsheet.
  8. Press Ctrl + V to paste.
  9. Select File and choose Download.
    download google sheets as xlsx file
  10. Select Microsoft Excel (.xlsx).
  11. Open the downloaded file in Excel.

Sometimes, the owner of the password-protected sheets might have enabled the Select locked cells and Select unlocked cells options. In such cases, you can copy the contents of the protected excel sheet and paste it into a new sheet.

Using Macro (Excel 2010 and lower)

For Microsoft Excel 2010 or lower, you can unprotect the password-protected Excel sheets using macro.

  1. Open the password-protected sheet that you want to unprotect.
  2. Right-click the name of your protected sheet at the bottom.
  3. Select View Code.
    view code in excel
  4. In the new window, right-click the name of your protected sheet in the left panel.
  5. Select Insert and click on Module.
    VBA insert module
  6. In the new window, enter the following code:
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 "Finished.”
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub


vba code in excel

  1. Press F5 to run the code.
  2. After executing the code, you should receive a popup saying finished.excel finished
  3. Click OK.

Now, your Excel sheet should be unprotected.

Use Third-party Applications

If the above methods don’t work, you can use third-party applications to unprotect Excel sheets without a password. Some applications you can use to do so are Passper for Excel, Excel Password Recovery Master, and Straxx Excel Password Remover.

how-to
Bishwo Tamli

I'm a tech enthusiast, and I've always been troubleshooting errors by myself for years. I also like keeping up to date with the latest technology and gadgets.

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
how-to-make-taskbar-smaller-windows-11

How to Make Your Taskbar Smaller on Windows 11

January 22, 2023
how to set chrome as default browser windows 11

How to Set Chrome as the Default Browser Windows 11

January 20, 2023
6800xt vs 3080

6800xt vs 3080 – Which One is Better?

January 20, 2023
You may also like
how to add weather to taskbar windows 11

How to Add Weather to Taskbar Windows 11

January 22, 2023
samsung-tv-flickering

Why is My Samsung TV Flickering? 10 Proven Ways to Fix It

January 22, 2023
msi laptop orange light always on

MSI Laptop Orange Light Always On – How to Fix It

January 22, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.