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

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