Macros that we wrote in Project Online in the Enterprise Global template are now disabled with the latest office upgrade.

Anonymous
2024-08-16T21:57:57+00:00

Hi,

We upgraded to the latest office version and now when we open MS Project and try to connect to our online profile, the only option we see is to Disable macros. Earlier we also had Enable Macros as an option. Can you pl let us know what we can do to retrieve that option?
I tried attaching a PNG file and also JPG file of the error message but the upload image function is failing here.

Microsoft 365 and Office | Project | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2024-08-20T14:25:21+00:00

Folks, We found an answer to this by talking to Microsoft. It requires registry update.

Save the below content into a updateMacro.reg file in your desktop. Run this file and it will do the magic of enabling the macros.
*****
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\MS Project\Settings]

"Fix9072568"=dword:00000101

*****

Was this answer helpful?

20+ people found this answer helpful.
0 comments No comments
Answer accepted by question author
Anonymous
2024-08-30T21:46:10+00:00

Please don't tell me your first name is John, because that's really my first name!

Yes, the guy from Microsoft recommended to roll back to Version 2407. Here are the instructions for anyone interested.

  1. Launch Command Prompt as an administrator and run the following command one after the other
  2. cd C:\Program Files\Common Files\Microsoft Shared\ClickToRun
  3. OfficeC2RClient.exe /update user updatetoversion=16.0.17830.20166

Was this answer helpful?

3 people found this answer helpful.
0 comments No comments

73 additional answers

Sort by: Oldest
  1. Anonymous
    2024-09-06T21:13:15+00:00

    Update from the support:

    „As per our discussion, I checked with my escalations team and confirmed the information you requested. The issue you’ve been experiencing, along with several other customers, has been identified by our engineering team. The problem is that the macros couldn’t be run when using Project Online from the enterprise global template.

    The new update released in Office includes a real-time virus check on the VBA code. If it detects something suspicious, it stops the code execution, which is why the error in the dialog appears. In this case, the scan is being overly cautious with the FileOpen and FileOpenEx methods. If you open a local file, you’ll find that they work because it’s not connected with the Enterprise Global Template.

    The DWORD added in the Regedit ensures that the virus check from Office code makes the macros a trusted source and allows them to execute properly. Without this, the Project will add the macros to the cache folder only. Hence, we had to add the key in Regedit.

    If you’re not willing to add the keyword in Regedit, you will receive a new update for Project in the next few weeks that will resolve this issue. Other than this, there is no more information to share with you, as our engineering team has redacted the details to avoid potential security violations.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-09-11T17:25:20+00:00

    2409 is out now and it seems to address the issue fully for me.

    I had to maintain at 2407 for the reg entry fix to work.

    I have removed the reg entry and updated to 2409 and all is well with both eglobal and local VBA.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-09-11T17:32:33+00:00

    According to the support the update with the fix should also remove the registry fix. Can some one confirm?

    Was this answer helpful?

    0 comments No comments