1-866-245-5224 sales@keystonelearning.com

Excel 2007: Enable Workbook Security

Excel 2007: Enable Workbook Security

So far, you’ve learned how to protect individual cells, whole worksheets and entire workbooks from editing mistakes. But, now we’re going to look at taking that security a step further by assigning passwords to the Excel file.

With this additional step, users will be required to enter a password just to open the Excel file.

Password Security

In the last lesson, you learned how to create passwords that prevent the modification of the Excel Window and Structure. But, for an added level of security, you can add an encrypted password. With this type of password, users will be required to enter the password just to open and view the workbook.

Additionally, you can have Excel recommend that the workbook should be opened as read-only. This way, users are reminded each time they open the Excel file that the data contained within the file is sensitive.

Setting An Encrypted Workbook Password

     
  1. Open the Office Menu
     
  2.  
  3. Choose Save As
     
  4.  
  5. Click Tools (lower-left corner of Save As Dialog Box)
     
  6.  
  7. Choose General Options…
     

Figure 13. General Options Dialog Box

    5.       Enter your password to open the file

    6.       Enter your password to modify the file (if desired)

    7.       Check Read-only recommended (if desired)

    8.       Click OK

 

Figure 14. Confirm Password Dialog Box

 

    9.       Enter your password to open, again

    10.   Enter your password to modify, again

    11.   Click Save

Removing An Encrypted Workbook Password

     
  1. Open the Office Menu
     
  2.  
  3. Choose Save As
     
  4.  
  5. Click Tools (lower-left corner of Save As Dialog Box)
     
  6.  
  7. Choose General Options…
     
  8.  
  9. Delete the passwords in both boxes
     
  10.  
  11. Remove the Read-only Checkbox (if desired)
     
  12.  
  13. Click OK
     
  14.  
  15. Click Save