Did you try the method given by Microsoft official KB?
I looked at it, but couldn't figure out what to do. Maybe I'm too uninformed, but:
1) In the "Learn about trusted publishers" section, it says that if you try to run the code, it will be diabled, and the Message Bar will notify me of potentially unsafe code. No Message Bar ever appeared.
2) I don't see anything else on that page that I understood as offering me an option to add the certificate to the Trust Center without a Message Bar.
Do you mean you can't see the message bar in any situation?
Not sure what you mean. When I try to run this macro, I never see the message bar. I don't ever recall seeing a message bar in Outlook, but maybe I'm wrong on that. I see a message bar all the time in Excel.
Please check attached the screenshot for the Trust Center setting regarding the message bar, try changing your setting to "notifications for all macros".
I made that change, which now generates a message each time the macro is run, but the message grays out the option to "Trust all documents from this publisher" which is what I really need.
If you really need to trust all documents, you should choose "enable all macros" in the previous setting in my screenshot.
Sorry, no. The purpose of signing the macro is so that it will be trusted. I absolutely don't want untrusted macros to run, but I should be able to run trusted macros without having to answer a question each time.
Okay, please check if there are items listed under Trust Center > Trusted Publishers?
There are other Trusted Publishers, but not my certificate. And no obvious way that I can see to add my certificate.
You cannot add trusted publisher directly under Trust Center > Trusted Publishers. A new trusted publisher is added when you are trying to run its code. As the official KB mentioned below.
If the code that Office has blocked identifies the publisher, and you are certain that you trust the publisher, you can add the publisher to the list of trusted publishers when you view more information about the security warning.
To add a publisher to the list of Trusted Publishers after a security warning
Open the file from the new publisher.
In the Security Warning area, click Enable Content > Advanced Options.
In Microsoft Office Security Options, click Trust all documents from this publisher.
Does it make sense now?
I hear what you're saying, but it doesn't answer my question. Most of what you've written is simply copied from the website you'd previously referred me to, and to which I had referred even before that. But it doesn't help because the security warning isn't popping up.
In the piece above, item (1), it says "open the file..." In the case of a macro that I wrote myself (or more particularly, that I copied), what is "the file" that one is supposed to open?
I am confused. You did see a Microsoft Outlook Security Notice and you took a screenshot and posted here. Did you click "Enable Macros" button on this message?
Sure, I clicked "enable macros." But that's not the answer because:
1) every time I reopen Outlook I have to click that "enable macros" button. I should be able to run the macro without having to go through the process of clicking a button (after all, that's why one would sign a certificate!)
2) I believe that once I enable macros, I've enabled all macros - which is poor security.
I feel like we're getting nowhere. The question is how to get my certificate into the Trust Center and it seems you don't know how to do that. Right?
Okay, if you don't think I can help you further, I will opt out and let other experts step in. Good luck.
Yes, I'd like you to opt out. Thanks.