How To Digitally Sign a Macro In Excel 2016?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
1. Click the File tab and select Options.
2. In the Excel Options dialog box, select Trust Center.
3. Select the Trust Center Settings button.
4. In the Trust Center dialog box, select the Macro Settings tab.
5. Select the Require Digital Signature option.
6. Select the Choose button and locate your digital certificate.
7. Select the OK button to save your settings.
8. When prompted, enter your password to unlock the certificate and confirm your choice.
9. Select the OK button in the Trust Center dialog box to save your changes.
10. Open the VBA Editor and select the Tools menu.
11. Select the Digital Signature option from the menu.
12. Select your digital certificate from the list.
13. Enter your password to unlock the certificate and confirm your choice.
14. Select the OK button to save your changes and digitally sign your macro.