How to Password Protect Microsoft Excel 2010 from Worksheet Level
Worksheet protection gives you a total control of spreadsheet or datasheet, by protecting each element your worksheet encompass. In this level of protection you can prevent users from modifying data, formula, name ranges, etc.
- 1)Click the File menu –> Save As option and click the tools dropdown arrow available on the bottom of the Save As dialog box.
- 2)Select General Options form the menu list.
- 3)This would display the following General Options dialog box. Using the Password to open and Password to modify text fields you can specify the password required for opening or modifying an excel workbook.
This will enable you to password protect Excel 2010 documents from opening and modifying.