Chapter 1: Protecting Workbooks and Worksheet Data
In This Chapter
Assigning a password to open a workbook
Assigning a password to make changes in a workbook
Using the Locked and Hidden protection formats
Protecting a worksheet and selecting what actions are allowed
Enabling cell range editing by particular users in a protected sheet
Protecting a workbook
Protecting and sharing a workbook
Before you start sending out your spreadsheets for review (especially out of house), you need to make them secure. Security in Excel exists on two levels. The first is protecting the workbook file so that only people entrusted with the password can open the file to view, print, or edit the data. The second is protecting the worksheets in a workbook from unwarranted changes so that only people entrusted ...
