| What Excel Files Can I Digitally Sign? |
|
|
|
You can digitally sign any native Excel file format, including templates. However, Excel 2002 and Excel 2003 are the only versions of Excel that recognize the digital signature.
If you digitally sign a shared workbook, Excel will not retain the digital signature because more that one person can make changes to the workbook. Additionally, you cannot code sign a macro project, because Excel will not allow you to create or make changes to macro projects in a workbook after it has been set up as shared workbook. How Do I Add A Digital Signature To A Workbook? To add a digital signature to your workbook, follow these steps: 1. On the Tools menu, click Options. 2. On the Security tab, click Digital Signatures. 3. Click Add. If the workbook has changed and is not yet saved, or if it is not saved in the Excel 2002 workbook format, you receive the following message: This workbook must be saved as a Microsoft Excel workbook before it can be digitally signed. Do you want to save the workbook? 4. Click Yes to display the Save As dialog box. You must save the file in the Microsoft Excel Workbook format to add the digital signature. 5. After you save the workbook, the Select Certificate dialog box is displayed. Click to select the certificate that you want to use, and then click OK. 6. Click OK to close the Digital Signatures dialog box. You Excel workbook is now signed. Notes • If you save your workbook after you add the digital signature, the digital signature will be removed. For example, when you click Save on the File menu after you digitally sign your workbook, you receive the following message: Saving will remove all digital signatures in the workbook. Do you want to continue? If you click Yes, the digital signatures will be removed from your workbook. • When you close and reopen the signed workbook, the Microsoft Excel title bar will display the words [Signed, unverified] in brackets after the workbook name to indicate that a digital signature has been added to the workbook. To verify that changes have not occurred in the signed workbook, follow these steps: 1. On the Tools menu, click Options. 2. On the Security tab, click Digital Signatures. 3. On the Signatures tab, if a signer is listed in the The following have digitally signed this document list, you can be assured that the file has not been changed since the digital signature was added to the file. How Do I Code Sign A Macro Project? To code sign your Visual Basic for Applications macro project, follow these steps: 1. Open the workbook containing the macro project you want to sign. 2. On the Tools menu, point to Macro and then click Visual Basic Editor. 3. In the Project Explorer, select the project you want to sign. 4. On the Tools menu, click Digital Signature. 5. Do one of the following: • If you have not previously selected a digital certificate, or if you want to use another one, click Choose, select the certificate, and then click OK two times. -or- • To use the current certificate, click OK. |
| < Prev | Next > |
|---|