复选框“信任对VBA项目模型的访问"是什么?意思是? [英] What does the checkbox "Trust access to the VBA Project Model" mean?

问题描述

我本能地在启用所有宏"之后立即单击信任对VBA项目模型的访问权限"，这仅仅是因为我没有时间去锻炼它是否会破坏我想要运行的代码.

"Trust access to the VBA project model" is something I instinctively click on right after "Enable all macros", simply because I don't have time to workout whether or not it will break the code I would like to run.

这很顽皮-我应该知道我在做什么和含义.假设我已经启用了所有宏，那么当我打开Pandora's Box信任对VBA项目模型的访问权限时，会暴露给我哪些额外的功能/危险?

This is naughty - I should know what I'm doing and the implications. Assuming I've enabled all macros already, what extra features/dangers are exposed to me when I open the Pandora's Box of trusting access to the VBA project model?

这行代码在不信任访问权限的情况下运行:

This line of code runs without trusting access:

VBAProject.Sheet1.Calculate

请您发布一些需要受信任访问权限的代码?

Please would you post some code that requires trusted access?

推荐答案

它允许您的代码通过执行诸如读取和更改其他代码或更改对象的代号之类的操作来访问VBA项目.基本上，它控制对通过Workbook.VBProject属性访问的任何内容的属性和方法的访问.

It allows your code to access the VBA project by doing such things as reading and altering other code or changing the codenames of objects. Basically it controls access to the properties and methods of anything you access via the Workbook.VBProject property.

这篇关于复选框“信任对VBA项目模型的访问"是什么?意思是?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！