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

Anonymous

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.

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

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

*****

0 comments

Answer accepted by question author

Anonymous

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.

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

0 comments

73 additional answers

Anonymous

2024-09-03T06:43:53+00:00

We only have digitally signed macros and block all others.

You can creat a code signing certificate yourself in PowerShell.

The certificate must be stored in "Trusted Publishers" of the user's certificate store to automatically trust signed code.

New-SelfSignedCertificate -DnsName $env:USERNAME -Type CodeSigning -CertStoreLocation Cert:\CurrentUser\My
Was this answer helpful?

0 comments No comments
Anonymous

2024-09-02T21:48:22+00:00
Hi Fabrice, After applying the registry fix, I also found that if I tried to execute:
```
FileOpenEx name:=serverFileName, ReadOnly:=True
```
the code would lose context and stop.

On another topic, has anyone tried to see if digitally signing code will get around the problem?
Was this answer helpful?

0 comments No comments
Anonymous

2024-09-02T08:36:50+00:00
Hello all

Hey Mark, John, whatever Edmonds you are... Your downdate tip was diamond for me anyway because it finally worked!
After 2 full days wasted in vain...

Waiting for the real patch now, dear MS Team. Please, check it before to pull it everywhere.

No connection (or is there some?), but in my excel macros some were curiously stopping in the middle of the execution for eg. on this :
```
Fin_Macro:
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
    SaveNoCheck = Null
```
Like usual error, except I could [Continue] the execution and it would exec until the end...

Does not stop anymore on those since I downdated on MSO Version 2407 this morning... Who knows...

I liked the irony: Application.DisplayAlerts = True was displaying an alert...
Was this answer helpful?

0 comments No comments