Excel 2010 Bible

Part IV: Using Advanced Excel Features

644

FIGURE 31.7

The Protect Workbook dialog box.

Protecting a workbook’s windows

To prevent others (or yourself) from changing the size or position of a workbook’s windows, you

can protect the workbook’s windows:

1. Choose Review ➪ Changes ➪ Protect Workbook.


2. In the Protect Workbook dialog box, select the Windows check box.


3. (Optional) Enter a password.


4. Click OK.

When a workbook’s windows are protected, the user can’t change anything related to the window

size or position. For example, if the workbook window is maximized when the windows are pro-

tected, the user cannot unmaximize the window. The windows can, however, be zoomed.

To unprotect the workbook’s windows, choose Review ➪ Changes ➪ Unprotect Workbook. If the

workbook’s windows were protected with a password, you are prompted to enter the password.

VB Project Protection

If your workbook contains any VBA macros, you may want to protect the VB Project to prevent

others from viewing or modifying your macros. Another reason to protect a VB Project is to pre-

vent its components from being expanded in the VB Editor Project window (which can avoid clut-

ter while you’re working on other VB project). To protect a VB Project

1. Press Alt+F11 to activate the VB Editor.


2. Select your project in the Projects window.


3. Choose Tools - xxxx Properties (where xxxx corresponds to your Project name).
   Excel displays the Project Properties dialog box.


4. In the Project Properties dialog box, click the Protection tab (see Figure 31.8).


5. Select the Lock Project for Viewing check box.