To unprotect a 'workbook' (not a 'worksheet)' Go to File Info Permissions and click 'Encrypt with Password' In this window, you will see astericks where your current password is filled. Remove the hidden password and click ok (the field where you enter the password will be blank).
How to Unprotect a Protected Excel Workbook/Sheet without PasswordA password-protected Excel Workbook refuses to let other unauthentic users view, add, move, delete, hide, and rename worksheets. If you need to edit/modify Excel file, but you don’t know the password or you have forgotten the password, how can you?
Actually, there is a great way that can help you.Way 1: Unprotect Workbook & Sheet with Workbook Protection Refixeris a powerful tool that can instantly remove any password that prevents you from making changes to an Excel sheet & workbook, and thus unprotect the Excel sheet & workbook without any data loss. Using the Workbook Protection Refixer program you can quickly remove worksheet & workbook password in Excel 2016/207.Note: Make sure your Excel file name extension is.xlsx. If it is an Excel file with.xls,.csv, or other format, please open it with your Excel program and then save it as an.xlsx file.Step 1: Install and run Workbook Protection Refixer on your computer.Step 2: Add your Excel file to Workbook Protection Refixer.Click the Open button and then navigate to the target Excel file, import it into this software.Step 3: Unprotect Excel sheet by Remove Password button.Once you click the Remove Password button, the sheet protection password is instantly removed.
If the Excel file has the workbook protection password, and readonly password, they can also be removed at once.The originally protected Excel worksheet is saved as an unprotected worksheet in the same location. You can open the unprotected worksheet and make changes to the sheets without restrictions.Note: The trial version is free and it only allows you to preview the features. The full version can truly unprotect Excel sheet & workbook, but it needs to be paid for. If you are sure you want to use it, pay few dollar to. If you want a, take a look at in this page. Way 2: Unprotect Excel Sheet/Spreadsheet with VBA codesIf you don’t mind using cumbersome steps or spending a little more time to unprotect your Excel sheet, use the VBA codes.
Steps are shown as follows:Step 1: Open the Excel worksheet you need to unprotect.Step 2: Press Alt + F11 to bring up the Microsoft Visual Basic for Applications (VBA for short) window.Step 3: From the list under Microsoft Excel Objects on the left-side pane, select any item ( e.g. Sheet1 ), and double-click on it. So a code input window will open on the right-side pane.Step 4: Copy the following codes and paste them into the code input window.
For Excel document, there are many security features built in that allow you control and protect your important and sensitive data in Workbook from unauthorized reading, editing or modifying. Even select the cells and ranges. You may not clear that securing Workbook data is a tiered process which offers several levels including the file encryption, editing restrictions and printing restrictions. The most common use of encryption is Excel workbook protection (file level), MS Excel uses VBA password to protect confidential and proprietary data in workbook. So, if the users could enter the correct password, then he can review the content in the entire workbook. However, if you forgot Workbook password, then you will not allowed to access the workbook and view the data, let alone edit the data.We understand how weighty your Excel file contents were otherwise you would not have set a password to protect it in the first place. But since now you are all locked out of your very own Excel workbook file, you need to do something to uprotect Excel workbook password.
Unprotect Excel Workbook Password with Knowing PasswordMS excel let you set a password to protect your Excel workbook data, then without the password, nobody can insert, delete, rename or copy the worksheet. If you want to completely remove protection from a workbook you previously protected, just follow the steps below and unprotect workbook without losing data.Open your Workbook and navigate to Review tab, click Protect Workbook command button in the Changes group. Then you can see there is a Windows dialog box pops up and asking you to type the password. Just type the the right password to unprotect workbook password. It works for Excel 2010/2013/2016.Method #3: Unlock Excel Workbook without Password 2016/2013/2010/2007The VBA code methods above will work for both MDI and SDI in Excel 2003 - 2007 version, however upprotecting the Workbook with VBA will have no use in Excel 2013 and above. In this situation, you may need a professional Excel workbook password unlocker to help you!
Here we highly recommend using tool, which is a fully working third party tool to simply unlock the password protection in Excel without damaging original data. This program provides two ways: Recover Excel open password with brute-force attack and and unlock Excel workbook and sheet password.
In order to boost the recovery process, Multi-core CPU and GPU acceleration features are also available. Method #3: Unprotect Excel Workbook Structure using VBAWhen you set a password to protect your Workbook, you may choose password or Structure option. If you chose the Structure box, then nobody can mess around with the sheets in the workbook like deleting or rearranging. If you forgot the workbook password, we can still have a way to unlock workbook password or Structure, just use VBA code.Step 1. Firstly, you need to open an your password protected excel workbook, then Press Alt+F11 to launch VBA Editor window.Step 2. Insert a Module for Insert Menu, then copy all code below and Paste in the code window of VBA editor.' Sub UnProtectWorkbookOn Error GoTo ErrorOccuredDim pwd1 As String, ShtName As Stringpwd1 = InputBox('Please Enter the password')If pwd1 = ' Then Exit SubShtName = 'Workbook as a whole'ActiveWorkbook.Unprotect Password:=pwd1MsgBox 'The workbook's structure has been Unprotected.'
![Unprotect Workbook Excel Unprotect Workbook Excel](http://www.quickbooks-training.net/wp-content/uploads/2013/09/091113_0445_AdvancedExc2.png)
Exit SubErrorOccured:MsgBox 'Workbook could not be UnProtected - Password Incorrect'Exit SubEnd SubProtecting your excel file is undoubtedly an obvious step to take when it contains rarely confidential list of details, but at the same time you need to know the way to unlock Execl workbook with or without password. Unlocking the file with password is not a big deal, but the real problem arises when you lose it. Because Excel doesn’t help you store your password, so, we suggest you store your passwords someplace safe.