Set "Access content programmatically" checkbox with vba

[kudude]

Hello,

I am trying to set the "Access content programmatically" checkbox to true within the permissions setting as in:
How to: Permit Code to Run Behind Documents with Restricted Permissions

I have found the msoPermissionObjModel option for adding individual users, but when I set this using

ActiveWorkbook.Permission.Add UserName, MsoPermission.msoPermissionObjModel

the box is not checked.

Is there a way to grant these permissions universally?

Thank you

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=317218#p317218
https://eileenslounge.com/viewtopic.php?p=316955#p316955
https://eileenslounge.com/viewtopic.php?p=316955#p316955
https://eileenslounge.com/viewtopic.php?p=316940#p316940
https://eileenslounge.com/viewtopic.php?p=316927#p316927
https://eileenslounge.com/viewtopic.php?p=317014#p317014
https://eileenslounge.com/viewtopic.php?p=317006#p317006
https://eileenslounge.com/viewtopic.php?p=316935#p316935
https://eileenslounge.com/viewtopic.php?p=316875#p316875
https://eileenslounge.com/viewtopic.php?p=316254#p316254
https://eileenslounge.com/viewtopic.php?p=316280#p316280
https://eileenslounge.com/viewtopic.php?p=315915#p315915
https://eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315744#p315744
https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315680#p315680
https://eileenslounge.com/viewtopic.php?p=315743#p315743
https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
https://eileenslounge.com/viewtopic.php?p=314950#p314950
https://www.eileenslounge.com/viewtopic.php?p=314940#p314940
https://www.eileenslounge.com/viewtopic.php?p=314926#p314926
https://www.eileenslounge.com/viewtopic.php?p=314920#p314920
https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[Excel Fox]

You might only be able to do that if you have administrative privileges. Are you able to manually do this?

[kudude]

You might only be able to do that if you have administrative privileges. Are you able to manually do this?

I do. In the macro, I've just created the file, and am able to manually do this after the macro is completed.

[kudude]

I'm not actually sure if this is possible now. I tried to record a macro of me changing it, and the source was blank.

Does that mean it's not possible?

[Excel Fox]

So is this something related to accessing an Excel file that is saved in a SharePoint portal? Where exactly are you checking / un-checking this checkbox?

[kudude]

So is this something related to accessing an Excel file that is saved in a SharePoint portal? Where exactly are you checking / un-checking this checkbox?

It's being emailed around, but we're using the MSFT id's for setting access permissions (Windows Rights Management must be installed).

File->Info->Permissions->Restrict Permissions by People->More Options : "Access Content Programmatically"

this option used to be checked when we set permissions, and now something has changed and it is not. Would like to actually set it so that we have control and it doesn't change "randomly" as it appears to be doing now