CHAPTER 34
Protecting Your Work
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
