Applying password protection to a workbook

In some cases, you might want to limit access to a workbook to only those who know the password.

To save a workbook file with a password, choose Office Prepare Encrypt Document.. Then, in the Encrypt Document dialog box (see Figure 2-20), specify a password and click OK. Then save your workbook.

Encrypt Document ^^^

Encrypt the contents of this file Password:

|T

Caution: If you lose or forget the password, it cannot be recovered. It is advisable to keep a list of passwords and their corresponding document names in a safe place. (Remember that passwords are case-sensitive.)

OK Cancel

Figure 2-20: Use the Encrypt Document dialog box to save a workbook with a password.

Figure 2-20: Use the Encrypt Document dialog box to save a workbook with a password.

0 0

Post a comment