Error: Invoke VBA: Programmatic access to VB Project is not trusted

Help Robot
, , ,
1

Hello,

When I try to Invoke VBA in Excel Application Scope, it is throwing the error as “Invoke VBA: Programmatic access to Visual Basic Project is not trusted”

I am aware about checking the Trust access to the VBA project object model , under Macro Settings in Options in Excel .

But, if we are running the same in Production, then all the machines requires this manual change.

Is there any other alternative to fix this Error?

2

Either this needs to be manually set, or your IT can set it through GPO policies.

3

Thank you!