• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

How to Unprotect Excel Sheet

January 16, 2024 by admin Category: How To

You are viewing the article How to Unprotect Excel Sheet  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

X

This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

This article has been viewed 12,606 times.

This wikiHow teaches you how to unprotect sheets from a Microsoft Excel workbook on Windows or macOS. If the sheet is password protected and you don’t know it, you can use Google Sheets or a VBA script (on earlier versions of Excel) to remove the protection.

Table of Contents

  • Steps
    • Using Microsoft Excel
    • Upload to Google Sheets
    • Using VBA code on Excel 2010 and earlier

Steps

Using Microsoft Excel

Image titled 6297644 1

Image titled 6297644 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/70/6297644-1.jpg/v4-728px-6297644-1.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/7/70/6297644-1.jpg/v4-728px-6297644-1.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open a workbook with protected worksheets in Microsoft Excel. Normally, you just need to double-click the file name on your computer.
Image titled 6297644 2

Image titled 6297644 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d1/6297644-2.jpg/v4-728px-6297644-2.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/d/d1/6297644-2.jpg/v4-728px-6297644-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Right click on the tab of the protected sheet. Each worksheet displays as a card along the bottom edge of Excel. Protected sheets often have a padlock icon on some versions of Excel. You need to right-click the card (or lock icon) to open the context menu. [1] X Research Source

  • If multiple sheets are protected, you need to remove the protection for each sheet separately.
Image titled 6297644 3

Image titled 6297644 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/81/6297644-3.jpg/v4-728px-6297644-3.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/8/81/6297644-3.jpg/v4-728px-6297644-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Unprotect Sheet . If the sheet does not have a password, it will be unlocked immediately. Otherwise, you will be asked to enter your password in the pop-up window.
Image titled 6297644 4

Image titled 6297644 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5d/6297644-4.jpg/v4-728px-6297644-4.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/5/5d/6297644-4.jpg/v4-728px-6297644-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the password and click OK . If the password is correct, the sheet will be unprotected.

  • If you don’t know the password, see How to Use Google Sheets. This allows you to upload files to Google Sheets, then all the security layers that have been added to Excel will be removed.
  • If you’re using Excel 2010 or earlier and don’t want to upload files to Google Sheets, see How to Use VBA code in Excel 2010 or earlier.
READ More:   How to Become a Celebrity

Upload to Google Sheets

Image titled 6297644 5

Image titled 6297644 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/34/6297644-5.jpg/v4-728px-6297644-5.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/3/34/6297644-5.jpg/v4-728px-6297644-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Go to https://drive.google.com using a web browser. If you have a Google account, you can use Google Sheets (a free online application similar to Excel) to remove protection from all worksheets in your workbook even if you don’t know the password.

  • If you’re not signed in to your Google account, follow the onscreen instructions to sign in.
  • If you don’t have a Google account, you can see How to create a Google account.
Image titled 6297644 6

Image titled 6297644 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/62/6297644-6.jpg/v4-728px-6297644-6.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/6/62/6297644-6.jpg/v4-728px-6297644-6.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,” bigHeight”:545,”licensing”:”<div class=”mw-parser-output”></div>”}
Click + New in the upper-left corner of the page.
Image titled 6297644 7

Image titled 6297644 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8e/6297644-7.jpg/v4-728px-6297644-7.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/8/8e/6297644-7.jpg/v4-728px-6297644-7.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click File Upload . The computer’s Open pane will open.
Image titled 6297644 8

Image titled 6297644 8

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/77/6297644-8.jpg/v4-728px-6297644-8.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/7/77/6297644-8.jpg/v4-728px-6297644-8.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the Excel file you want to edit and click Open . The file will be uploaded to Google Drive.
Image titled 6297644 9

Image titled 6297644 9

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/85/6297644-9.jpg/v4-728px-6297644-9.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/8/85/6297644-9.jpg/v4-728px-6297644-9.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Double-click the Excel file in Google Drive. You may need to scroll down to find it. A preview of the file will open.
Image titled 6297644 10

Image titled 6297644 10

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8c/6297644-10.jpg/v4-728px-6297644-10.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/8/8c/6297644-10.jpg/v4-728px-6297644-10.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Open with menu. This option is at the top of the preview. A menu will be expanded.
Image titled 6297644 11

Image titled 6297644 11

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0c/6297644-11.jpg/v4-728px-6297644-11.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/0/0c/6297644-11.jpg/v4-728px-6297644-11.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Google Sheets . So the file will be opened for editing on Google Sheets, any sheet protection added in Excel will be removed.
Image titled 6297644 12

Image titled 6297644 12

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d3/6297644-12.jpg/v4-728px-6297644-12.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/d/d3/6297644-12.jpg/v4-728px-6297644-12.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Re-download the file to your computer. If you want to continue working with files in Microsoft Excel rather than Google Sheets, you can download this new unprotected version of the workbook by following these steps:

  • Click the File menu in the upper-left corner of the sheet.
  • Click Download As .
  • Click Microsoft Excel (.xlsx) .
  • Select the folder to save the file. If you want to keep the original of the file (with protected sheet), enter a new name for the file to be loaded.
  • Click Save to load the file.

Using VBA code on Excel 2010 and earlier

Image titled 6297644 13

Image titled 6297644 13

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2b/6297644-13.jpg/v4-728px-6297644-13.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/2/2b/6297644-13.jpg/v4-728px-6297644-13.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the workbook with the protected worksheet in Excel by double-clicking the file name on the desktop. Excel files usually end with the extension .xls or .xlsx .

  • Apply this method if you have tried unlocking the sheet but found that the sheet is password protected (and you don’t know the password).
  • This method will not work on Excel 2013 and later.
READ More:   How to Make Glow Glass Jars
Image titled 6297644 14

Image titled 6297644 14

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a7/6297644-14.jpg/v4-728px-6297644-14.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/a/a7/6297644-14.jpg/v4-728px-6297644-14.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Save the file as xls format. If the file you are working with has the extension “.xlsx” (common if the spreadsheet was created or edited on later versions of Excel), you need to convert the file to Excel 97-2003 format. (.xls) first to apply this method. Here’s how: [2] X Research Sources

  • Click the File menu in the upper right corner.
  • Click Save As .
  • Go to the folder where you want to save the file.
  • Select Excel 97-2003 (.xls) from the “Save as type” or “File Format” menu.
  • Click Save .
  • Follow the on-screen instructions to perform all the necessary conversions.

Image titled 6297644 15

Image titled 6297644 15

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4e/6297644-15.jpg/v4-728px-6297644-15.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/4/4e/6297644-15.jpg/v4-728px-6297644-15.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Press Alt + F11 to open the Visual Basic Editor.
Image titled 6297644 16

Image titled 6297644 16

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/62/6297644-16.jpg/v4-728px-6297644-16.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/6/62/6297644-16.jpg/v4-728px-6297644-16.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Right-click the filename in the “Project – VBAProject” pane. This item is at the top of the left pane. Make sure you right-click the option that contains the filename (the “.xls” extension) is at the top. A menu will be expanded. [3] X Research Sources
Image titled 6297644 17

Image titled 6297644 17

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8b/6297644-17.jpg/v4-728px-6297644-17.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/8/8b/6297644-17.jpg/v4-728px-6297644-17.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Insert in the menu. Another menu will expand.
Image titled 6297644 18

Image titled 6297644 18

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/db/6297644-18.jpg/v4-728px-6297644-18.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/d/db/6297644-18.jpg/v4-728px-6297644-18.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,” bigHeight”:545,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on Module to insert a new module that we will paste some code into.
Image titled 6297644 19

Image titled 6297644 19

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b8/6297644-19.jpg/v4-728px-6297644-19.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/b/b8/6297644-19.jpg/v4-728px-6297644-19.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Copy code. Highlight the code below and then press Ctrl + C (PC) or ⌘ Command + C to copy:

 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 _ _ End Sub 
Image titled 6297644 20

READ More:   How to Connect Hisense TV to Phone

Image titled 6297644 20

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4e/6297644-20.jpg/v4-728px-6297644-20.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/4/4e/6297644-20.jpg/v4-728px-6297644-20.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Right-click the new module and select Paste . The copied code will appear in the module window.
Image titled 6297644 21

Image titled 6297644 21

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fd/6297644-21.jpg/v4-728px-6297644-21.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/f/fd/6297644-21.jpg/v4-728px-6297644-21.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Press F5 to execute the code. Excel will run the code, and it will take a few minutes. Once done, a new password will appear in a pop-up window.

  • The new password will be a random number that replaces the original password.
  • Image titled 6297644 22

    Image titled 6297644 22

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f0/6297644-22.jpg/v4-728px-6297644-22.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/f/f0/6297644-22.jpg/v4-728px-6297644-22.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
    Click OK on the Password dialog box that pops up. The new password will appear, but you don’t need to write it down. Just click OK and the sheet protection layer will be removed automatically. [4] X Research Sources

    • If you converted the file format before, you can now save the workbook again as a .xlsx file.
  • X

    This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

    The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

    This article has been viewed 12,606 times.

    This wikiHow teaches you how to unprotect sheets from a Microsoft Excel workbook on Windows or macOS. If the sheet is password protected and you don’t know it, you can use Google Sheets or a VBA script (on earlier versions of Excel) to remove the protection.

    Thank you for reading this post How to Unprotect Excel Sheet at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

    Related Search:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks

    Category: How To

    Previous Post: « Top 999+ mahesh hd images – Amazing Collection mahesh hd images Full 4K
    Next Post: Top 999+ aravinda sametha images – Amazing Collection aravinda sametha images Full 4K »

    Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge