Excel > Excel 2007 Intermediate > Excel Protection

Excel File Protection

Workbooks can be protected to prevent unauthorised changes.

A password can be set to prevent unauthorised users from opening the workbook, or to ensure they can only open a read only copy.

Save and protect a workbook

1. Click the Office Button and then click Save As

The Save As dialogue box is displayed

2. Click Tools > General Options

The General Options dialogue box is displayed



3. Enter a password in the Password to open and/or Password to modify fields
4. Click Ok

The Confirm Password dialogue box is displayed



5. Re-enter the password
6. Click Ok
7. Finish saving the workbook as normal

On opening the workbook the user will be prompted to enter a password. In the image below the user has the option of opening a read only workbook, or entering a password to open it for modifying.

Protect an existing workbook

1. Click the Office Button, select Prepare and click Encrypt Document

The Encrypt Document dialogue box appears



2. Enter a password
3. Click Ok
4. Re-enter the password in the Confirm Password dialogue box
5. Click Ok

Workspace Files Workbook Protection

Guides