Set "Access content programmatically" checkbox with vba

[jtw5074]

Hello,

I am trying to use VBA to set the "Access content programmatically" checkbox to true within the permissions of a file (File-> Protect Workbook -> Restrict Access -> Restricted Access)

When you go to the Permission dialogue and select "More Options", it allows you to select several checkboxes (such as "Print Content", "Access content programatically", etc. I am looking to do this automatically using VBA. However, when I try and do that manually and record a macro, the macro is blank. Is there a way to do this automatically? I've attached a screenshot of the permissions dialogue box.

Thanks!!!

 

[Norie]

No screenshot so I'm not sure exactly what you are referring to.

However it sounds like something that is not possible to do using code for, valid, security reasons.