How to unprotect a password protected worksheet. So what do you do. In the case of a password protected worksheet where you are unable to Edit the data you can try the following steps to unprotect your worksheet. Step 1 Press ALT + F11 or click View Code on the Developers Tab. Step 2 Double click on the worksheet that is password protected. Protect and UnProtect Worksheets in Excel VBA is useful when we work with the templates or some worksheets which structure will not change but data may change. Or we may want to restrict the users to not to modify the structure of the worksheet.
WindowsmacOSOnline
To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.
Note: The screen shots in this article were taken in Excel 2016. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.
Notes: Protecting the workbook is not the same as protecting an Excel file or a worksheet with a password. See below for more information:
- To lock your file so that other users can't open it, see Protect an Excel file.
- To protect certain areas of the data in your worksheet from other users, you have to protect your worksheet. For more information, see Protect a worksheet.
- To know the difference between protecting your Excel file, workbook, or a worksheet, see Protection and security in Excel.
Protect the workbook structure
To protect the structure of your workbook, follow these steps:
- Click Review > Protect Workbook.Note: The Windows option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. Select the Windows option if you want to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows.
- Enter a password in the Password box.Important: The password is optional. If you do not supply a password, any user can unprotect and change the workbook. If you do enter a password, make sure that you choose a password that is easy to remember. Write your passwords down and store them someplace safe. If you lose them, Excel cannot recover them for you.
- Click OK, and retype the password to confirm it, and then click OK.
How can I tell if a workbook is protected?
On the Review tab , see the Protect Workbook icon. If it’s highlighted, then the workbook is protected.
If you click on the bottom of a sheet inside your workbook, you will notice that the options to change the workbook structure, such as Insert, Delete, Rename, Move, Copy, Hide, and Unhide sheets are all unavailable.
The Protect Workbook option in the Info menu also indicates that the workbook's structure is protected. To view this option, click File > Info > Protect Workbook.
![Unprotect Workbook Excel Unprotect Workbook Excel](http://support.moonpoint.com/software/office/unprotect-workbook/review-tab.png)
Unprotect an Excel workbook
Click Review > Protect Workbook. Enter the password and then click OK.
To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.
Note: The screen shots in this article were taken in Excel 2016. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.
Notes: Protecting the workbook is not the same as protecting an Excel file or a worksheet with a password. See below for more information:
- To lock your file so that other users can't open it, see Protect an Excel file.
- To protect certain areas of the data in your worksheet from other users, you have to protect your worksheet. For more information, see Protect a worksheet.
- To know the difference between protecting your Excel file, workbook, or a worksheet, see Protection and security in Excel.
Protect the workbook structure
To protect the structure of your workbook, follow these steps:
- Click Review > Protect Workbook.Note: The Windows option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. Select the Windows option if you want to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows.
- Enter a password in the Password box.Important:
- The password is optional. If you do not supply a password, any user can unprotect and change the workbook. If you do enter a password, make sure that you choose a password that is easy to remember. Write your passwords down and store them someplace safe. If you lose them, Excel cannot recover them for you.
- Passwords in Excel for Mac have a 15-character limit. You cannot open a workbook or document that has been password-protected in the Windows-based version of Excel or if the password is longer than fifteen characters. If you want to open the file in Excel for Mac, ask the Windows-based author to adjust the password length.
- Retype the password and click OK.
How can I tell if a workbook is protected?
On the Review tab , see the Protect Workbook icon. If it’s highlighted, then the workbook is protected.
If you click on the bottom of a sheet inside your workbook, you will notice that the options to change the workbook structure, such as Insert, Delete, Rename, Move, Copy, Hide, and Unhide sheets are all unavailable.
Unprotect an Excel workbook
Click Review > Protect Workbook. Enter the password and then click OK.
![Excel Excel](/uploads/1/2/5/5/125535404/309927582.png)
Excel Online can’t open or edit workbooks protected by a password. In fact, passwords can’t be added, changed, removed, or recovered from Excel Online.
If you try to open a password protected workbook, you’ll see a message like this:
If you want to add a password to a workbook you are working on in Excel Online, and you have Excel desktop application, you can use the Open in Excel button to open the workbook and password protect the workbook. But going forward, you’ll only be able to make changes to the workbook in Excel desktop application.
- Click Open in Excel and password protect the workbook.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.