-
Set "Access content programmatically" checkbox with vba
-
You might only be able to do that if you have administrative privileges. Are you able to manually do this?
-
Quote:
Originally Posted by
Excel Fox
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.
-
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?
-
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?
-
Quote:
Originally Posted by
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?
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
