Microsoft Office Tutorials and References
In Depth Information
SELF-SIGN YOUR MACROS FOR CO-WORKERS
Excel conﬁ rms that a new signature has been created.
To sign a macro, follow these steps:
Go to the Visual Basic editor.
From the Visual Basic editor menu, choose Tools, Digital Signature.
Click the Choose button in the Digital Signature dialog.
Choose the signature you just created and click OK.
Excel now lists the project as signed, as shown in Figure 150:
Figure 150. Yo u a t ach the certii cate to the project.
To enable the certiﬁ cate on another computer, follow these steps for Excel
Select Tools, Macro, Security. In the Security dialog, select Medium.
Open the workbook that is signed. Excel displays the Security Warning
dialog shown in Figure 151.
Figure 151. Excel indicates that the macro is signed by you.