Use of Microsoft Office Macros
As part of our ongoing effort to protect our campus systems, we will be disabling the use of unsigned, unapproved macros in Microsoft Office applications beginning September 30, 2021.
Although macros are a powerful tool that can aid in productivity and automation, they can also perform a variety of malicious activities, and pose a security risk to you and Davidson College. If you need to continue the use of certain macro-enabled files, please contact ti@davidson.edu for assistance.
Once you have the appropriate permissions, you will need to digitally sign the macro by following the “How to Digitally Sign a Macro” steps below.
How to Digitally Sign a Macro
Once you have received permissions to enable a specific macro from T&I, follow the below steps to digitally sign the macro.
1. Open the file that contains the macro project that you want to sign.
2. On the Developer tab, in the Code group, click Visual Basic.
(Note: If the Developer tab is not available: Click the File tab. Click Options. Click Customize Ribbon. In the Customize the Ribbon list, click Developer, and then click OK.)
3. In the Visual Basic options, on the Tools menu, click Digital Signature.
4. When the Digital Signature dialog appears, click Choose.
5. The “Signed Macro” certificate should pop up automatically, click OK.
6. Save your file, close, and re-open. The Macro should now run.
For more information, see Microsoft's support article on this process.