The information applies to Excel workbooks in Microsoft Excel 365, Microsoft Excel 2019, 2016, and 2013.
How to Unlock an Excel Workbook as the Owner
Microsoft Excel is packed with features.
One such feature is the ability to protect your Excel files at thecell, spreadsheet, orworkbooklevel.
Sometimes it’s necessary to unprotect Excel workbooks to ensure data changes apply correctly.
fire up the protected spreadsheet, and selectReview>Unprotect Sheet.
You could also right-hit the protected spreadsheet, then selectUnprotect Sheet.
you’re free to identify a protected spreadsheet under the Changes section of the Review tab on theribbon.
If the spreadsheet is protected, you see the Unprotect Sheet option.
Enter the password used to protect the spreadsheet, then selectOK.
Your spreadsheet will now be unprotected and it can be modified.
pop launch the protected spreadsheet.
reach the Visual Basic code editor by either pressingALT+F11or selectDeveloper > View Code.
In the Code window of the protected sheet, enter the following code:
SelectRunor pressF5to execute the code.
The code will take several minutes to run.
Once finished, you’ll receive a pop-up with a password.
SelectOKand your spreadsheet will be unprotected.
This is not the original password and you don’t need to remember it.
