Open the password-protected Excel file and enter the password.
Click on the "File" option on the toolbar and select the "Information" tab.
In the Protect Workbooks and Worksheets area, find the Cancel Password button next to Password Protection.
Enter the password you originally set and click OK to successfully cancel the password.
Open the password-protected Excel file and enter the password.
Click on the "File" tab and select "Save As".
In the Save As dialog box that pops up, click "General Options" in the "Tools" options list.
In the General Options dialog box, you can see that the password already exists in the Open Permission Password column. Select the password and delete it, then save the file. In this way, Excel's "Open Password" is lifted.
Open the password-protected Excel file and enter the password.
Press the "Alt + F11" keys to open the Visual Basic for Applications editor.
Locate and double-click the encrypted Excel file in the editor.
Enter the corresponding VBA code in the code window to replace the password in the code with the password you set. For example:
vbaCopy CodeSub RemoveProtection() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Unprotect Password:="yourpassword" Next ws End Sub
Replace yourpassword with the password you set.
Press "F5" to run the macro code. Excel will automatically remove the password protection of all worksheets in the workbook.
If none of the above methods are applicable, you can also try using a third-party tool to remove Excel password. These tools often have simple and easy-to-use interfaces and powerful password-cracking capabilities.
It is recommended to use the online decryption function of this platform, or the document password recovery master platform, and the fun decryption online decryption platform