Word macros failing

Question

Word macros failing

I have several users that use mail macros on a regular basis for mailing out legal documents. They are all using Office 365 for apps. Word Trust center is set to allow macros. Starting today, some of the users started receiving the "The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros."
If I go into Word -> Trust Center Settings, macros are still set to on.
Anyone have any suggestions?

Answer 1

Charles Kenyon 1,601

Except for short-term testing, you should never allow all macros.
See https://learn.microsoft.com/en-us/DeployOffice/security/internet-macros-blocked

Answer 2

Hi @Ryan Wilderman

> If I go into Word -> Trust Center Settings, macros are still set to on.

Do you choose the option of "Enable all macros"?

Could you please tell us where is the document with macros stored?
I suggest you add the storage path into trusted location for a test. (Word > File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location.)

I also suggest you try to copy the macros from VBA editor (Alt+F11) and paste code into a new local and blank document, then check the issue again.

Any updates, welcome to let us know.

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.

Answer 3

Ryan Wilderman 126

Yes, enable all macros. The macros are stored within word. We have about 40 of them, Word -> View -> Macros -> View Macros.

Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor

2022-09-08T03:03:49.157+00:00

Hi @Ryan Wilderman
Thanks for your reply.
Does this issue occur with new local Word documents with macros?
If yes, I suggest you try to create a valid digital certificate with SELFCERT.EXE, and apply it to the project via VBA Editor >Tools > Digital Signature. For more details, please check "Create a valid digital certificate with SELFCERT.EXE". (Please Note: Since the web site is not hosted by Microsoft, the link may changed without notice. Microsoft does not guarantee the accuracy of this information.)
Then repair Office from Control Panel.
If not, I would suggest you try my previous suggestions.

Answer 4

Ryan Wilderman 126

ingl0if

Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor

2022-09-08T03:19:38.127+00:00

Hi @Ryan Wilderman

Thanks for your sharing.
Could you please check the version number of your Office?
You can go to one Office app, File > Account > Product Information.

Answer 5

Ryan Wilderman 126

2208 Build 16.0.15601.20078

Seems that the problem went away last week and now has returned.

Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor

2022-09-13T08:58:51.687+00:00
Hi @Ryan Wilderman

Thanks for your sharing.

If this version still does not solve your issue, I would suggest you try following command to roll back your Office to previous version.
"C:\Program Files\Common Files\microsoft shared\ClickToRun\officec2rclient.exe" /update user updatetoversion=16.0.xxxxx.xxxxx

You can enter the command in Run dialog (Win+R),

Go to Version History, and check the version number to replace the "xxxxx.xxxxx".
If your office is Current Channel (One Office app > File > Account > Product Information), and you want to roll back to Version 2207 (Build 15427.20194), then you can use 15427.20194 to replace xxxxx.xxxxx, then command should be "C:\Program Files\Common Files\microsoft shared\ClickToRun\officec2rclient.exe" /update user updatetoversion=16.0.15427.20194.
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor

2022-09-20T02:55:09.98+00:00

Hi @Ryan Wilderman
I am checking this thread, is there any update?
If so, welcome to post back,

Word macros failing

6 answers

Activity