I created a spreadsheet and decided to password protect it. Later, I decided to just protect certain cells in certain worksheets and thought I would remove the workbook password. This has turned out to be harder than I thought.
I looked into Help and performed the following steps:
1.Use the password to open the spreadsheet.
2.Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
3.In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
4.Save the spreadsheet.
I still get this dialog when I open the spreadsheet: