For a workbook composed of multiple spreadsheets, select Protect Workbook followed by Unprotect Workbook. Enter the Workbook password again when prompted and select OK to remove protections.

Type the password into the "Password to unprotect sheet" field and click "OK." Re-enter the password when prompted and click "OK" to protect the spreadsheet. Press "Ctrl-S" to save the changes.

At the file level, you can password protect an Excel workbook in two ways: You can determine who can get in and who can save changes.

Protecting a worksheet in Excel 2003 prevents others users from editing it. For example, if you have tracked and charted your business's sales on a sheet, you will want co-workers to access the ...