It is possible to create a macro in an Excel sheet that unlock the sheet which is already protected by a password. Users can easily prepare a document in the sheet and then lock it again with a ...

Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

Check the "Show Password" box. Enter the administrator password into the "Password" field and click the "Allow" button. Copy the password and use it to unlock Excel.

Do not worry if you have lost your Excel password there are ways that you can still access spreadsheets. Check out our guide on how to unlock Excel spreadsheets without a password to learn more.

Once you lock a cell, you'll be asked to set a password. Excel will ask you for this password if you try to unlock the cell. Visit Business Insider's homepage for more stories.