Microsoft Office Tutorials and References
In Depth Information
You can also hide your formulas so that they won’t appear in Excel’s formula bar when the cell is
activated. To do so, select the formula cells and make sure that the Hidden check box is marked
in the Protection tab of the Format Cells dialog box.
Protecting a workbook’s structure
When you protect a workbook’s structure, you can’t add or delete sheets. Choose the
Review➜Changes➜Protect Workbook command to display the Protect Structure and Windows
dialog box, as shown in Figure 2-19. Make sure that you enable the Structure check box. If you
also mark the Windows check box, you can’t move or resize the window.
Figure 2-19: The Protect Structure and Windows dialog box.
Applying password protection to a workbook
In some cases, you may want to limit access to a workbook to only those who know the password.
To save a workbook file with a password, choose File➜Info➜Protect Workbook➜Encrypt With
Password to display the Encrypt Document dialog box (see Figure 2-20). In this dialog box, you
can specify a password that’s required to open the workbook.
Figure 2-20: Use the Encrypt Document dialog box to save a workbook with a password.
Protecting VBA code with a password
If your workbook contains VBA code, you may wish to use a password to prevent others from
viewing or modifying your macros. To apply a password to the VBA code in a workbook, activate
the VBE (Alt+F11) and select your project in the Projects window. Then choose Tools➜ xxxx
Properties (where xxxx corresponds to your Project name) to display the Project Properties