User Permissions

The security settings shown in the previous pages are "all or nothing." Either the file is locked or it is not. The Permissions are applied to the sheet or to the entire workbook.

 

1. Introduction to Permissions by People Permission can also be based on Users and Groups. When you Restrict Permissions by People you can decide who has access to your file. The Permissions are authenticated by Digital Signatures: each person has a secure ID that identifies them.

 

So, this process has two steps: getting a Digital ID, and then granting Permission to Digital IDs that you trust.

 

A Digital Signature shows who signed this document and if it was changed since it was signed. It is a method for determining if the email, spreadsheet or document is authentic.

 

Keep going...

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.1. Apply workbook settings, properties, and data options: Add a Digital Signature

File ->Info->Permissions->Protect Workbook->Add a Digital Signature