在Excel选项窗口中,左侧列表中找到并点击“信任中心”(Trust Center)。 然后点击右侧的“信任中心设置”(Trust Center Settings)按钮。 选择宏设置: 在信任中心设置窗口中,左侧列表中找到并点击“宏设置”(Macro Settings)。 启用宏: 在宏设置部分,你可以看到几个选项。为了启用宏,通常你会选择“启用所有宏(不推荐...
在Excel选项对话框中,左侧有多个选项,找到并点击“信任中心”。信任中心是Excel用来管理安全设置的地方。 4. 打开信任中心设置 (Open Trust Center Settings) 在信任中心页面,点击右侧的“信任中心设置”按钮。这将打开一个新的对话框,您可以在这里更改宏的安全设置。 5. 选择宏设置 (Select Macro Settings) 在信任...
2 第一步,打开excel ,点击file。3 第二步,点击在file下拉列表最下面的Options。4 这个时候我们打开一个如图所示的选项框。5 选择Trust Center。6 再点击Trust center settings 7 这时候会弹出来一个trust center settings的选项框,我们悬着Macro settings。8 将Enable all Macros选中,点击OK ,再讲trust cent...
需要注意的是,如果Excel文件带有宏,打开时会提示“启用内容”,需要选择“启用宏”才能正常运行该文件中的宏。如果想要取消这个提示,可以在“选项”中找到“Trust Center”,然后选择“Trust Center Settings”,在弹出窗口中选择“Macro Settings”,将“Disable all macros without notification”改为“Enable all macros (...
如果你的OFFICE是2007版的,那么按左上角的圆形按钮,再按Excel Options(选项),再进到Trust Center(信赖中心),再按Trust Center Settings(信赖中心设置),再进到Macro Settings(宏设置),然后选择 Enable all macros(启用所有宏)。多长
You can also access the Trust Center in Excel Options. To do that, clickOptions, and then clickTrust Center>Trust Center Settings>Macro Settings. For more information about macro security, see the following topics: Add, remove, or change a trusted location ...
则应用程序将检查File > Options > Trust Center > Trust Center Settings... > Macro Settings下的...
Next, click on "Trust Center" > "Trust Center Settings":Finally, click on "Macro Settings":The default (and recommended) option is to "Disable VBA macros with notification," which prompts you to enable (or disable) macros when opening the file....
Excel does not provide anything to access Trust center Settings via command line or VBA. some of the things in Excel we are not able to automate. this is the one of that. because it is possible that some one can misuse it and try to change settings. so we can't do this. you have...
The Excel Trust Center settings can be accessed through the following steps: File > Options > Trust Center > Trust Center Settings > Macro Settings When the checkbox is selected, the above settings configured for VBA macros will also apply to XLM macros. To disable XLM mac...