Re: How to unprotect the excel sheet if forgot the password
Press Alt + F11 to open the Visual Basic Editor. Right-click the workbook name on the left pane (Project-VBAProject pane) and select Insert > Module from the context menu.
Subsequently, how do I unprotect a workbook in Excel 2013 without the password?
Unprotecting Excel Spreadsheets Without The Password
- Press Alt + F11 (or go to View Code in the Developer’s Tab)
- In the window that appears, paste in this code (courtesy of University of Wisconsin-Green Bay) Sub PasswordBreaker() ‘Breaks worksheet password protection. …
- Press F5 (or click Run) and wait a minute or so…..
In this regard, how do I unprotect an Excel workbook without the password? How to Remove Password from Excel Spreadsheet (Unprotect Excel)
- Step 1: Go to Control panel.
- Step 2: Click on Folder Options.
- Step 3: Open View Tab.
- Step 4: Uncheck “Hide Extension for the known file type”
- Step 5: Select the excel file.
- Step 6: Change the extension of your Excel file from . …
- Step 7: Open Zip File & Extract.