Chapter 34: Protecting Your Work
34
In previous versions of Excel, you could also protect a workbook’s windows. This type of protection prevented others
(or yourself) from changing the size and the position of a workbook’s windows. Because of the single-document inter-
face introduced in Excel 2013, the ability to protect windows is no longer available.Protecting a VBA Project
If your workbook contains VBA macros, you may want to protect the VBA Project to prevent
others from viewing or modifying your macros. To protect a VBA Project, follow these steps:- Press Alt+F11 to activate the VB Editor.
- Select your project in the Projects window.
- Choose Tools ➪
Properties (where corresponds to
your Project name). The Project Properties dialog box appears. - Select the Protection tab (see Figure 34.8).
FIGURE 34.8
Protecting a VBA Project with a password- Select the Lock Project for Viewing check box.
- Enter a password (twice).