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: Most helpful
  1. John Project 49,720 Reputation points Volunteer Moderator
    2024-08-30T15:11:31+00:00

    Florian Obradovic,

    Just like Fabrice said in his response, it still doesn't solve the problem. Neither 0x0000101 nor 0x00000001 unlocks the ability to run VBA code in Project.

    Any other suggestions? Maybe there is more to it than simply adding the new "Fix..." Dword to the registry settings.

    John

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-08-30T15:01:00+00:00

    "If set to "Deactivate macros without notification" it won't work" which makes sense 😂

    I don't understand why you have a different value instead of just "00000001".

    Just create a new file with a text editor and save it as Fix9072568.reg (or any-name.reg)

    Windows Registry Editor Version 5.00
    
    [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\MS Project\Settings]
    
    "Fix9072568"=dword:00000001
    

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-08-30T14:28:35+00:00

    We have also French Project but Office 365 edition and version 2406 and the registry workaround works using Sunil Nadig above answer value :

    "Fix9072568"=dword:00000101

    But, under Project, verify the parameters for Macros execution (and make sur there is no Policies).
    We leave notification to users:

    If set to "Deactivate macros without notification" it won't work

    No need to reboot, just restart Project.

    You should contact Microsoft about your edition and version (we got rapid replies).

    Was this answer helpful?

    0 comments No comments