Enable Macros via Powershell


i have powershell script creates excel file, , within runs macro embed oleobject.  this going used field engineers , therefore on different computers.  to run script, macro settings need set to "enable macros..." , "trust access vba project object model." 

is there way can incorporated powershell script? ideally activated , deactivated @ end.

i suspect can't automated, , need done manually run script.

any suggestions appreciated.

now think security implications of that.  make sense.

these settings maintained in a  secure store encrypted registry.

try posting in vba developer forum see if knows of tool can this.


¯\_(ツ)_/¯



Windows Server  >  Windows PowerShell



Comments

Popular posts from this blog

Group Policy Event ID 1058 Error Code 1326 (The user name or password is incorrect)

Suspicious event log Event ID: 4905

DCOM received error "2147746132" from...