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
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
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

73 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-30T15:48:55+00:00

    FYI:

    Regarding to Microsoft Support, the registry key will be automatically removed, after the fixed update has been released!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-30T15:27:12+00:00

    For everyone, this is the Workaround that Microsoft sent us with an open case:
    The product engineering team is actively investigating this issue. However, because it relates to a security fix, resolving it may take some time. The estimated release date for the fix is by the end of September 2024.

    In the meantime, you can use the following workaround by adding a specific registry key:

    Windows Registry Editor Version 5.00

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

    "Fix9072568"=dword:00000001

    Once the fix is applied, the presence of this registry key on the user’s machine will no longer be necessary, as the update will handle all required actions.

    So, sorry for the confusing with value "dword:00000101" published above by Sunil Nadig.
    But, we have ourself tested with that value successfully before getting Microsoft feedback!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-30T15:24:30+00:00

    No, thats the workaround.

    Check, if:

    • you have macro policies that prevent macro execution
    • Computer\HKEY_CURRENT_USER\Software\Policies\Microsoft\office\16.0\ms project\security
    • if the enterprise global VBA project is signed (Alt+F11 > Tools > Digital Signature)
    • My version is Microsoft® Project 2019 MSO (Version 2408 Build 16.0.17928.20114) 64-bit

    Was this answer helpful?

    0 comments