Outlook macros no longer run until VB editor is opened

Jay Burgess 45 Reputation points
2023-07-17T15:49:07.17+00:00

I was sent here after posting on the Microsoft Community pages. Hopefully this is now the right place to try and resolve the following issue:

I've been running VBA macros in Outlook for years hooked to toolbar buttons. I shut down my computer every night, and I noticed earlier last week that after my morning reboot, none of the macros worked!

I discovered accidentally, though, that by simply opening the Visual Basic editor, they would start working for the day. I don't even need to give the editor mouse-focus, just simply clicking on the "Visual Basic" button on the "Developer" tab causes them to work again.

It's not a huge deal to open the editor every morning, but it seems like I've picked up a new bug or some setting has changed that I need to update.

Ideas?

Outlook
Outlook
A family of Microsoft email and calendar products.
4,444 questions
{count} votes

Accepted answer
  1. Faery Fu-MSFT 19,006 Reputation points
    2023-07-18T06:20:55.3166667+00:00

    Hi @Jay Burgess ,

    Welcome to our forum! From your description, after you restart the Outlook last week, Outlook Macro is no longer working automatically, right?

    Did you change the macro security in File > Options > Trust Center? If you have set to allow all macros, but it still doesn't work, it is recommended you try to leave your macro security setting to only allow self-sign certificate Macros,

    If you untick the Apply macro security settings to installed add-ins option, does that make a difference?

    User's image

    If above doesn't help, the issue may be more related macros. To solve it better, you can post under “Office Development “, so that more developer experts can provide you with more targeted help.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.