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

Excel 2003: Enable Workbook Security

Excel 2003: 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

Using the Protection command (located on the Tools menu) you can 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. Choose File: Save As
     
  2.  
  3. Click Tools (upper-right corner of Save As Dialog Box)
     
  4.  
  5. Choose General Options…
     

Figure 7. Save Options Dialog Box

   4.      Enter your password to open the file

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

   6.      Check Read-only recommended (if desired)

   7.      Click OK

 

Figure 8. Confirm Password Dialog Box

   8.      Enter your password to open, again

   9.      Enter your password to modify, again

   10.  Click Save



Removing an Encrypted Workbook Password

     
  1. Choose File: Save As
     
  2.  
  3. Click Tools (upper-right corner of Save As Dialog Box)
     
  4.  
  5. Choose General Options…
     
  6.  
  7. Delete the passwords in both boxes
     
  8.  
  9. Remove the Read-only Checkbox (if desired)
     
  10.  
  11. Click OK
     
  12.  
  13. Click Save