lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I am reading about macro settings and found this link about the option
[] trust access to the vba project
Mine is not check and I ran many small macros without problem so far. I read what is explained below but did not understand it well. Could you please explain to me why I need this option. Thank you very much.
https://bettersolutions.com/vba/macros/macro-settings.htm
Trust access to the VBA project object model (Default is off) This setting is for developers and is used to allow programmatic access to the VBA object model from any Automation client. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. This option was available in 2003 and has not changed.
All macros in trusted locations are allowed to run regardless of your macro security setting.
I am reading about macro settings and found this link about the option
[] trust access to the vba project
Mine is not check and I ran many small macros without problem so far. I read what is explained below but did not understand it well. Could you please explain to me why I need this option. Thank you very much.
https://bettersolutions.com/vba/macros/macro-settings.htm
Trust access to the VBA project object model (Default is off) This setting is for developers and is used to allow programmatic access to the VBA object model from any Automation client. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. This option was available in 2003 and has not changed.
All macros in trusted locations are allowed to run regardless of your macro security setting.