Before protecting the worksheet:
- Select all cells that users ARE allowed to change;
- On the [gs keyboard], press Ctrl + 1 to open the Format Cells dialog box;
- On the Protection tab, remove the check mark from Locked;
- Click OK, to close the dialog box;
Protect the worksheet in Excel 2007
- On the Excel Ribbon, click the Review tab;
- Click Protect Sheet.
Protect the worksheet in Excel 2003
- Click the Tools menu, then click Protection;
- Click Protect Worksheet.
I've lost my password!
Well, there are passwords and there are passwords.
- One is to open the file;
- one other is to unprotect the [gs worksheet];
- still another is to unprotect the [gs workbook];
- yet another one is to unprotect the Excel VBA [gs macro] code.
File and VBA passwords cannot be cracked by a "normal macro", [gs workbook] and [gs worksheet] passwords are fairly easy. A search for "excel password" at http://www.google.com/ will find both commercial and free solutions of varying quality and brutality.