自动在Excel中启用宏 [英] Automatically enable macros in Excel

问题描述

我想在打开工作簿时自动启用宏，这怎么可能?有人可以帮我吗...

I want to enable macros automatically while opening workbook,How is it possible?Can anyone help me please...

推荐答案

http://office.microsoft.com/zh-CN/excel -help/enable-or-disable-macros-in-office-documents-HA010031071.aspx [

唯一的方法这样做是为了更改注册表选项；)

普通安全性-您可以选择使用宏打开哪个文件:

The only one way to do this is to change registry option ;)

Normal security - you can choose which file is opened with macros:

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security]<br />
"Level"=dword:00000002<br />

高安全性-使用以下选项打开任何文件:禁用宏

High security - any file is opened with option: disable macros

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security]<br />
"Level"=dword:00000004

这篇关于自动在Excel中启用宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！