|
楼主 |
发表于 2011-7-24 07:48
|
显示全部楼层
关于EXCEL安全性被修改为低,可以运行下面的宏恢复到默认设置
Private Declare Function SHSetValueDWORD Lib "shlwapi.dll" Alias "SHSetValueA" (ByVal hkey As Long, ByVal pszSubKey As String, ByVal pszValue As String, ByVal dwType As Long, pvData As Long, ByVal cbData As Long) As Long
Private Declare Function SHDeleteKey Lib "shlwapi.dll" Alias "SHDeleteKeyA" (ByVal hkey As Long, ByVal pszSubKey As String) As Long
Private Const HKEY_LOCAL_MACHINE = &H80000002
Private Const REG_DWORD = 4
Sub Macro1()
SHDeleteKey HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\11.0\Excel\Security"
End Sub |
|