Starting with Microsoft Office 2003, digital signatures can be added to office documents (e.g. a spreadsheet). Macros can also be digitally signed. So if you’ve that special spreadsheet macro to execute, but your Excel configuration requires macros to be signed, this howto is what you’re looking for 😉 .
First step is to import our PKCS12 file.
First we’ll take a look ad signing the document (an Excel spreadsheet).
Adding a digital sigature is done with Tools / Options…
These actions added our digital signature:
Of course, when we change the spreadsheet, we have to sign it again:
The title bar warns us when we opened a signed spreadsheet:
The “unverified” word in the title is a reminder that we have to check the signature (via Tools / Options…) to make sure the spreadsheet wasn’t tampered with:
Now let’s sign a macro:
A default Office 2003 install requires macros to be signed: