If I sign the VBAProject and then change data, does the signature remain
valid? What about if I change the file name?

"msnews.microsoft.com" wrote in message
...
I've been asked to help find a solution for a group that needs to
digitally sign macros in an Excel workbook that is automatically
generated. The workbook is generated on a server that does not have
automation objects by streaming data into a pre-existing template workbook
that contains a lot of complex macro code. These are produced at a rate
of approximately 5000 per day. The group that is producing these
workbooks wants to minimize the perception of risk to the recipients by
having, depending on the users security settings, the system prompt with
the details of the digital certificate rather than the generic "this
contains macros and may not be safe" message.

The question behind all of this background is "can anybody point me in the
right direction to automate the application of a digital signature to the
macros in the generated file?".

Thanks