• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Printing and Protecting Your... > Preventing Unauthorized Changes to a...

Preventing Unauthorized Changes to a Workbook

In many businesses, one person or team is in charge of creating workbooks that many people in the business use. In some cases, the person who created the workbook doesn’t want the people who are using the workbook to change it. In other cases, the creator wants users to be able to enter data but does not want users to change formatting or any of the formulas or functions that perform the calculations.

Whatever the case, you can password-protect a worksheet, as explained in the following steps. The steps might seem backward to you at first; you unlock certain cells to permit users to change them before you password-protect the worksheet. However, after you password-protect the worksheet, you cannot unlock cells, so you must mark the cells as unlocked before password-protecting the worksheet. Now that you know that, take the following steps to password-protect a worksheet:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint