Excel 2007 的 VBA 宏可以在哪里关闭?
宏拒绝在 Windows Server 2003 上的 Excel 2007 中运行。 功能区上的宏和视觉基本图标呈灰色。 如果我打开带有宏的工作簿,我会收到警告:“此工作簿已丢失其 VBA 项目、ActiveX 控件和任何其他与可编程性相关的功能。” 如果我尝试在 VSTO 中创建新的 Excel 模板(Excel 当时已关闭),我会收到错误:“无法启用对 Microsoft Office Visual Basic for Applications 项目系统的编程访问......”
我检查了 VBA 是否已安装(最初没有安装,我通过 Office 设置添加了它)。 我也试过卸载并重新安装office和VBA,没有骰子。 我制作了一个启用宏的工作簿。 我将工作簿的位置设置为可信。 我将 Excel 选项/信任中心下可用的所有安全设置配置为允许一切无提示。 我设置了“启用所有宏”和“信任对 VBA 对象模型的访问”。 我下载了组策略管理模板并验证了这些都不是通过组策略设置的。
这是我在 Google 中能找到的所有尝试,但显然还有另一个地方可以关闭 VBA。 我还能去哪里看?
Macros refuse to run for me in Excel 2007 on Windows Server 2003.
The macro and visual basic icons on the ribbon are grayed out.
If I open a workbook with a macro, I get the warning: " This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."
If I try to make a new excel template in VSTO (Excel is closed at the time), I get the error: "Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled. . ."
I checked that VBA was installed (originally it wasn't, I added it via office setup). I also tried uninstalling and reinstalling office and VBA, no dice.
I made a macro-enabled workbook.
I set the workbook's location to trusted.
I configured all of the security settings available under Excel Options/Trust Center to allow-everything-no-prompts.
I set "Enable all macros" and "Trust access to the VBA object model".
I downloaded the group policy admin templates and verified none of this is being set via group policy.
That's everything I can find in Google to try, but clearly there is another place that VBA can be turned off. Where else can I look?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您确定没有适当的系统策略来禁止 VBA 吗?
编辑:如果您还没有看过这些内容,请阅读一些内容:
http://support。 microsoft.com/kb/282847/en-us
http://support.microsoft.com /kb/287567
http://support.microsoft.com/kb/ 281954/en-us - 适用于早期版本,但部分/全部可能仍与 2k7 相关
Are you sure there isn't a system policy in place that inhibits VBA?
Edit: Some reading, if you've not already seen these:
http://support.microsoft.com/kb/282847/en-us
http://support.microsoft.com/kb/287567
http://support.microsoft.com/kb/281954/en-us - Applies to earlier versions, but some/all may still be relevant to 2k7
在 Excel 中 Alt+F11 看看是否有可以更改的选项....
Alt+F11 in excel and see if there is an option in there that you can change....