Protecting a Workbook

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Protecting a Workbook

Introduction

You can protect a workbook to make sure that not just anybody can modify it. You can protect a workbook when saving it for the first time or you can protect an existing workbook. You have many options.

When protecting a workbook, you give it a password. Anybody who wants to use that workbook would need the password. You can also control whether people would be allowed to open and only view the workbook, or be able to open and modify its contents.

Protecting a Workbook

To protect a workbook when you save it for the first time, click the Office Button and click Save. In the lower section of the dialog box, click Tools and click General Options...

This would display the General Options dialog box with two text boxes:

General Options

If you want to allow only a person with a valid password to open the workbook, type that password in the Password to open text box. If you click OK, a Confirm Password text box would come up. If you want a person who opens the workbook to be able to change its content, click the Password to modify text box, type a password (the same or another) and click OK. A Confirm Password would come up. In the Confirm Password dialog box(es), you must type the same password you had provided in the corresponding first text boxes.

When a workbook has been protected with one or two passwords, a user can open it to view or change. If you give only the Open password, when opening the workbook, a user can enter that password and click Read Only. When a workbook is open with this option, its title bar would display Read-Only on the right side of the name:

Practical LearningPractical Learning: Protecting a Workbook

  1. Start Microsoft Excel
  2. In cell C2, type College Park Auto Repair
  3. Click cell B4 and type Year
  4. Complete the worksheet with the following values
     
    Year Make Model Part Name Unit Price
    2006 Dodge Caravan SE L4 2.4 Radiator Cap 6.65
    2000 Toyota Rav4 2WD/4-Door Thermostat Gasket 4.95
    2006 Kia Rio 1.6DOHC16V 4-DR Thermostat 14.45
  5. To save the workbook, click the Office Button and click Save
  6. Change the name to cpar1
     
    Save As
  7. Click the Tools button and click General Options...
  8. In the Password to Open text box, type P@ssword1 and press Tab
  9. In the Password to modify text box, type Passw0rd1 
     
  10. Click OK
  11. In the Confirm Password dialog box, type P@ssword1
     
  12. Click OK
  13. In the second Confirm Password dialog box, type Passw0rd1 and press Enter
  14. Click Save
  15. To close the workbook, click the Office Button and click Close
  16. To open the workbook, click Office Button and click cpar1.xlsx
     
  17. In the Password dialog box, type P@ssword1
  18. Click OK
     
  19. In the second dialog box, click Read Only
  20. Click Year and type Car Year
  21. To save, press Ctrl + S
  22. Read the message box and click OK
  23. On the Save As dialog box, click Cancel
  24. To close the workbook, click the Office Button and click Close
  25. When asked whether you want to save, click No
  26. To re-open the workbook, click Office Button and click cpar1.xlsx
  27. In the Password dialog box, type P@ssword1 and click OK
  28. In the second Password dialog box, type Passw0rd1
     
    Password
  29. Click OK
  30. Click Year and type Car Year
  31. To save the workbook, press Ctrl + S

Unprotecting a Workbook

If you don't need to workbook protected anymore, you can remove its password. To do this, start saving the workbook. You can click the Office Button, position the mouse on Save As, and click Save Excel Workbook. Click Tools and click General Options. Delete the password and click OK. After deleting the password, click Save. You would be asked whether you want to overwrite the file. Click Yes.

Practical LearningPractical Learning: Removing a Password

  1. Click the Office Button -> Save As -> Excel Workbook
  2. In the lower section of the dialog box, click Options -> General Options...
  3. As the password is selected, press Delete
  4. Press Tab
  5. Press Delete
     
    General Options
  6. Click OK
  7. Click Save
  8. When asked whether you want to replace the file, click Yes