vba Excel 2007 为单个 Excel 文档启用宏
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10047714/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel 2007 enable macros for a single excel document
提问by Wes
Is there anyway a user can have macros enabled by default for a single workbook but not other ones? It is annoying you constantly have to enable them every time you open a particular workbook. Thanks
无论如何，用户是否可以默认为单个工作簿启用宏，但不能为其他工作簿启用宏？每次打开特定工作簿时都必须不断启用它们，这很烦人。谢谢
回答by bouvierr
You can set trusted locations (folders) from which files can be opened without asking for enabling macros: http://office.microsoft.com/en-us/word-help/create-remove-or-change-a-trusted-location-for-your-files-HA010031999.aspx
您可以设置可在不要求启用宏的情况下打开文件的受信任位置（文件夹）：http: //office.microsoft.com/en-us/word-help/create-remove-or-change-a-trusted- location-for-your-files-HA010031999.aspx
回答by Rohit Agrawal
In case, it is a workbook created by you then you can add your digital certificate to it. Digital certificate created by you will be trusted in your machine. Digital Certificate can be created by the tool listed in MS Office tools(start menu). And after creating digital certificate, you can attach it to your workbook in vba editor in excel.
如果它是您创建的工作簿，那么您可以向其中添加您的数字证书。您创建的数字证书将在您的机器中受到信任。可以通过 MS Office 工具（开始菜单）中列出的工具创建数字证书。创建数字证书后，您可以在excel的vba编辑器中将其附加到您的工作簿。
