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-28T23:07:59+00:00

    We are also experiencing this with our Project here at my org. We have a global template as well, that lives in SharePoint. I think that's the issue, as Excel files with macros also won't load from the internet. They will load just fine when first downloaded locally, but since the Project files are all stored in a SharePoint site, and the global template file is also there, Project won't even open without clicking "disable all macros". This is a pretty large bug that Microsoft needs to look at as soon as possible. We added our SharePoint site as a trusted location in Project, and even added it as a "Trusted Site" in internet options. The registry hack did not work for us either so we are completely dead in the water here while we wait for a fix. I understand the security implications of allowing macros run from the internet, but if we add our sharepoint to the trusted locations, I don't see how it could possibly be a security risk.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-28T15:59:28+00:00

    Thank everyone for publishing updated information.
    We have the same situation and are waiting updated information before deciding deploying or not a registry key to users.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-28T08:15:46+00:00

    Hi

    As many of you and our customers ask for an official statement of Microsoft here some more infos:

    • there is no official statement by Microsoft but they provide this fix to their customers as a workaround
    • What does this Fix9072568 ?
      • It's a so called feature-switch which is a standard procedure to implement if the developers believe could break things.
        If things break, you can enable the feature-switch to disable / rollback the affected code instead of uninstalling the whole update 
        Example: "we're going to fix a bug or security vulnerability but there is a risk that this could be a breaking change"

    Here are two PowerShell scripts which you can use in Intune (or SCCM / any other MDM or GPO) as a proactive remediation to fix this on your clients:

    https://gist.github.com/florian-obradovic/a32950dc91fd342e1cf870143a321b60

    Best regards, Flo from The Project Group

    [PII marked by MSFT]

    Was this answer helpful?

    0 comments