Microsoft Office Tutorials and References
In Depth Information
SELF-SIGN YOUR MACROS FOR CO-WORKERS
Back in the Security Warning dialog, choose Enable Macros.
Close the workbook.
Reopen the workbook. You get the same security warning shown in Figure
152, but the checkbox for Always Trust Macros from This Publisher is now
enabled. Check this box. Click Enable Macros.
From now on, this computer will be able to open your signed macros without
In Excel 2007, the process is similar:
Open Excel. Make sure the macro security is set to Disable All Macros with
Open your workbook. The information bar says Macros Have Been
Click Options. The next dialog warns that the digital signature is invalid and
cannot be trusted. Below that, click Show Signature Details.
Click View Certiﬁ cate.
Click Install Certiﬁ cate.
Click Next three times and click OK four times.
Close the workbook in Excel.
Reopen the workbook in Excel.
Click the Options button in the information bar.
Choose Always Trust Content from This Publisher.
This computer is now ready to open your signed macros.
Additional Details: The one downside of using this approach is that if a bug
arises at your co-worker’s computer, you can no longer ﬁ x the macro there on
the spot. You have to send the macro back to yourself, ﬁ x the macro, re-sign
the macro, and send it back to your co-worker.
Summary: Self-signing your macros makes it easier for your co-workers to
The original post was provided by Greg Truby. The topic was nominated by