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