Chapter 31. Protecting Your Work
IN THIS CHAPTER
Protecting worksheets
Protecting workbooks
Protecting Visual Basic Projects
Other related topics
The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified. Excel has several protection-related features, and those features are covered in this chapter.
31.1. Types of Protection
Excel's protection-related features fall into three categories:
Worksheet protection: Protecting a worksheet from being modified, or restricting the modifications to certain users
Workbook protection: Protecting a workbook from having sheets inserted or deleted, and also requiring the use of password to open the workbook
Visual Basic (VB) protection: Using a password to prevent others from viewing or modifying your VBA code
|
About Information Rights ManagementExcel supports ... |
Get Excel® 2010 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.