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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-09-05T16:04:40+00:00

    Hi,

    Yes I tried the change in the registry (both number) but like for some others it didn't worked. My understanding is that it only works for server version and our Macros are local.

    I cannot tried the downgrading version because I don't have the administrator right to do so but I would say that it must work. Yesterday when the first user (based in Australia) had the issue I made a survey and all users (me including) having the 2407 version had the macro working. But the 2408 update has since infected more PC and almost of us must use this temporary solution.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-09-05T15:10:11+00:00

    Hello,

    We found a way to "solve" the problem. [...]

    Hello Antoine,

    did you try the Fix registry workaround and/or the downgrade to version 2407 workaround?

    Wich version are you running ? Server or standalone ? Build number ?

    thanks

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-09-05T14:17:07+00:00

    Hello,

    We found a way to "solve" the problem.

    Like you our Macros are in the Global.MPT and despite they are visible we cannot launch them. We discover that if we double click on the Global.MPT a second session of the Global.MPT is started (visible in the VBA editor) where the macros are working . It cause an issue when you close the MSProject because it tries to save the Global.MPT and 2 are opened. The solution is therefore:

    1. Go to the folder where your Global.mpt is stored and rename it Global_MyMacro.MPT.
    2. Add the folder where your Global_MyMacro.MPT is stored as thrusted location
    3. Double click on the Global_MyMacro.MPT You should have your Macros working From now any time you start a MSProject file or MSProject you will have to launch Global_MyMacro.MPT also. Looking forward the full problem resolution by Microsoft.

    Was this answer helpful?

    0 comments