2] Unprotect Sheet/Workbook to unlock the grayed-out menu The reason why you see several menu options being grayed out in your Excel worksheet could be the fact that it is password protected.

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.

How to Unprotect Specific Areas in Excel. Protecting your Excel worksheet prevents others from making changes to the original data. If you want to allow others to add or change data in only ...

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 ...

How to Unprotect a Spreadsheet in Office 2007. Microsoft Office 2007 has several programs that facilitate the day-to-day operations of small businesses, including PowerPoint, Word and Excel ...

In Microsoft Excel, each cell is locked automatically. In enabling protection of a spreadsheet, it will often be faster to unlock everything and then re-enable the lock on chosen cells.