I saved a new excel file from a template that was password protected and now my file is password protected. I know the password, so I can unprotect the tabs to edit what I need, but it's a hassle to do this every time. When I save and exit the file, all the tabs become password protected again when I re-open it.
Is there any way to remove this password protect so I no longer have to unprotect every time I use the file? I know you can "Allow users to edit ranges", which allows you to type in certain cells. But this won't allow you to format any of those cells.
2 Answers
To remove protection from a worksheet
- On the Review tab, in the Changes group, click Unprotect Sheet.
Note The Protect Sheet option changes to Unprotect Sheet when a worksheet is protected.
If prompted, type the password to unprotect the worksheet.
Then Save the file again. Close Excel and open the sheet again and you shouldn't be asked for password.
Source: Password Removal Excel 2010
to permanently unprotect a protected .xls sheet in MS Office 2010:
- click on File tab
- protected sheets are listed under Permissions section (under Info). Click on Unprotect next to the sheets that you want to unprotect and if prompted enter password.
- click on Save As, and save as .xlsx [without VBa (Macros)]
Note: When saved as .xls, the sheets would be protected again.
