Chapter 30Protecting Your Work

IN THIS CHAPTER

  1. Protecting worksheets
  2. Protecting workbooks
  3. Protecting Visual Basic Projects
  4. Creating PDFs and checking documents

The concept of “protection” gets a lot of attention in the Excel forums. It seems that many users want to learn how to protect various workbook elements from being overwritten or copied. Excel has several protection-related features, and those features are covered in this chapter.

Types of Protection

Excel's protection-related features fall into three categories:

  • Worksheet protection: Protecting all or part of a worksheet from being modified or restricting the modifications to certain users
  • Workbook protection: Protecting a workbook from having sheets inserted or deleted and requiring the use of a password to open the workbook
  • Visual Basic (VB) protection: Using a password to prevent others from viewing or modifying your VBA code

Protecting a Worksheet

You may want to protect a worksheet for a variety of reasons. One common reason is to prevent yourself ...

Get Excel 2016 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.