Digital Signature

I have applied a digital signature to my spreadsheet. However, everytime I
make a change in the spreadsheet, such as changing a value in a cell, when I
close out it wants to drop my signature. Is there a way to apply the
signature to just the code? Also, is there away to have the signature
autimatically update when I, the developer, changes the code?

JJ

ALT + F11 to open Visual Basic Editor.

CTRL + r to open Project Explorer.

Select your Project/Workbook and Tools>Digital Signature>Choose.

Should find your Certificate in the list. Select it and Save the workbook.


Gord Dibben Excel MVP

On Mon, 2 May 2005 14:19:05 -0700, "JJ" <[email protected]> wrote:

>I have applied a digital signature to my spreadsheet. However, everytime I
>make a change in the spreadsheet, such as changing a value in a cell, when I
>close out it wants to drop my signature. Is there a way to apply the
>signature to just the code? Also, is there away to have the signature
>autimatically update when I, the developer, changes the code?