excel启用宏在哪里_Excel 2010在不启用的情况下运行宏

In the old days, if you opened a file that contained macros, a warning message popped up on the screen. That has changed, and now Excel 2010 runs macros without enabling, in some situations.

在过去，如果您打开一个包含宏的文件，则屏幕上会弹出一条警告消息。 情况已经改变，现在在某些情况下Excel 2010运行宏而不启用。

Excel 2003中的消息 (Message in Excel 2003)

Here is the message from Excel 2003, giving me the option to Enable Macros or Disable Macros.

这是来自Excel 2003的消息，为我提供了启用宏或禁用宏的选项。

Of course, you only saw that warning if you had your security level set to Medium, which allowed you to choose whether or not to run macros.

当然，只有将安全级别设置为“中”时，您才看到该警告，该警告使您可以选择是否运行宏。

Excel 2007中的安全栏 (Security Bar in Excel 2007)

Things changed in Excel 2007, and there was a security bar, instead of a popup warning. This caused problems, because many people didn’t notice the bar, and complained that their files were broken, because the macros didn’t run.

在Excel 2007中，情况发生了变化，并且出现了安全栏 ，而不是弹出警告。 这引起了问题，因为许多人没有注意到该栏，并且抱怨说他们的文件已损坏，因为宏没有运行。

When you clicked the Options button in the security bar, another message box appeared, where you could enable macros.

当您单击安全栏中的“选项”按钮时，将出现另一个消息框，您可以在其中启用宏。

It took two clicks to get started in a file with macros, but things worked, once you were familiar with the new security bar.

两次单击即可使用宏文件启动文件，但是一旦您熟悉了新的安全栏，一切就可以正常进行。

Excel 2010中的安全栏 (Security Bar in Excel 2010)

Things changed again in Excel 2010, with different wording in the security bar. In this version it warns that macros have been disabled, and there is a button – “Enable Content”. That made it easier to get to work – there’s one click instead of two.

在Excel 2010中，安全栏中的措辞有所不同，情况再次发生了变化。 在此版本中，它警告宏已被禁用，并且有一个按钮–“启用内容”。 这样一来，上班就更容易了-只需单击一下即可，而不是单击两次。

It took me a while to notice (okay, two years, but who’s counting?), but there is another change in the security settings.

我花了一段时间才注意到(好的，两年了，但是谁在数？)，但是安全性设置还有另一处变化。

When you click that button to enable the content, your file becomes a Trusted Document.

当您单击该按钮以启用内容时，您的文件将成为Trusted Document 。

• You won’t see that security warning again, unless you move the file, or rename it.
  除非您移动文件或重命名文件，否则您将不会再看到该安全警告。
• The file will open with macros enabled, even if you change your macro settings to “Disable all macros without notification”.
  即使您将宏设置更改为“禁用所有宏而无须通知”，该文件也会在启用宏的情况下打开。

关闭受信任的文档 (Turning Off Trusted Documents)

Occasionally, I’ll put files in a Trusted Location, so they’ll open with macros enabled, and no security warning. There’s a list in the Trust Center, where you can see the existing locations, and add or remove locations.

有时，我会将文件放在“受信任的位置”，这样它们将在启用宏的情况下打开，并且没有安全警告。 信任中心中有一个列表，您可以在其中查看现有位置，以及添加或删除位置。

I looked for a similar list of Trusted Documents, but there isn’t one in the Trust Center. Apparently it’s stored in the registry, and I don’t want to poke around in there, unless it’s an emergency.

我在寻找类似的“受信任文档”列表，但是“信任中心”中没有一个。 显然，它存储在注册表中，除非有紧急情况，否则我不想在那儿四处探寻。

Unfortunately, with Trusted Documents, it’s all or nothing. In the screen shot below, you can see the Trust Center settings for Trusted Documents – no list, just a couple of check boxes and a button.

不幸的是，对于“受信任的文档”，它是全部或全部。 在下面的屏幕快照中，您可以看到“受信任文档”的“信任中心”设置-没有列表，只有几个复选框和一个按钮。

• If you don’t want a specific file to become trusted automatically, you’ll have to disable the Trusted Documents feature, so nothing is trusted automatically.
  如果您不希望特定文件自动受信任，则必须禁用“受信任的文档”功能，因此不会自动信任任何文件。
• You can’t remove a specific file from the Trusted Documents list, you’ll have to clear all the Trusted Documents from the list.
  您无法从“受信任的文档”列表中删除特定文件，而必须清除列表中的所有“受信任的文档”。

我的设置 (My Settings)

Since it’s all or nothing for Trusted Documents, I’ve decided to go with nothing. If I can’t manage the list, I’d rather not have a list.

由于受信任文档的全部内容或全部内容，我决定不做任何事情。 如果我无法管理列表，则宁愿没有列表。

• I added a check mark to “Disable Trusted Documents”, and clicked the button to clear all the Trusted Documents.
  我在“禁用受信任的文档”上添加了一个复选标记，然后单击按钮以清除所有受信任的文档。
• If I want a file to open with no security warnings, I’ll put it in a Trusted Locations folder.
  如果我希望打开文件时没有任何安全警告，则将其放在“受信任的位置”文件夹中。

Am I the last person to notice this “feature” of Trusted Documents? Do you use them, or have them disabled?

我是最后一位注意到受信任文档“功能”的人吗？ 您使用它们还是禁用它们？