Locking a Spreadsheet

Microsoft Outlook 2003 (full product)
January 16, 2010 at 17:37:54
Specs: Windows XP, 1.0Gb
I have a Excel 2003 workbook with eight spreadsheets. Is it possible to lock one spreadsheet so a password is needed to open it?

Thank you.

See More: Locking a Spreadsheet

Report •

January 17, 2010 at 04:57:54

From the Menu bar select Tools - Protection - Protect Sheet...
Make your selections from the dialog box and enter a password.

All cells should be locked by default.
To be sure, before protecting the sheet, select the whole sheet (click the square between the A and 1 column and row markers) right click over any cell, select Format Cells... and select the Protection Tab.
The Locked check box should have a check mark in it. If it is a solid color, click to make it a check mark - click OK and proceed to Protecting the sheet.


Report •
Related Solutions

Ask Question