How to Remove Password from Protected Sheet on Ms. Excel

There are several ways to remove password from the protected sheet, but I am choosing one that is simplest and easier. That is Using Google Sheets.

1. Open Google sheet on your browser
2. Click File – Import, and upload your protected Excel files. Choose an option: Replace Spreadsheet.
   
   
   
3. Then Click File – Download as Microsoft ( .xlsx ) files.
   
   
   
4. Open downloaded Excel files and you have unprotected Excel files from your original protected Excel files. It’s Worked!

For your information, I already tried using VBA Editor.

1. Open the Excel file.
2. Press "Alt + F11" to open the VBA editor.
3. In the VBA editor, click on "Insert" and then choose "Module" to insert a new module. In the module window, paste the following code:

            Sub UnprotectSheet()

                Dim ws As Worksheet

                    For Each ws In ActiveWorkbook.Worksheets

                        ws.Unprotect

                    Next ws

            End Sub

Then Press "F5" to run the code. This will unprotect all sheets in the workbook and Save the file

But it still asks you for the password like the image above. So today with this method, we can’t use it anymore.

And the third way is by save as your protected Excel files to .zip files and then edit the .xml files. Yes maybe it works but it’s too complicated for some users.

Good Luck.

Hope this is useful.

Software :

Microsoft® Excel® for Microsoft 365 MSO (Version 2305 Build 16.0.16501.20074) 64-bit

Windows 10 Pro 64 bit.