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.
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.
Steps
Using Microsoft Excel
- If multiple sheets are protected, you need to remove the protection for each sheet separately.
- 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.
Upload to Google Sheets
- 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.
- 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
- 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.
- 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.
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
- The new password will be a random number that replaces the original password.
- If you converted the file format before, you can now save the workbook again as a .xlsx file.
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: