Sub banMacro()
Application.AutomationSecurity = 3 '禁用宏
Workbooks.Open ThisWorkbook.Path & “\1.xlsm”
Application.AutomationSecurity = 2 '恢复选择
End Sub
【VBA】用VBA打开excel,禁止被打开文件运行宏或自身VBA
最新推荐文章于 2024-04-17 05:00:00 发布
Sub banMacro()
Application.AutomationSecurity = 3 '禁用宏
Workbooks.Open ThisWorkbook.Path & “\1.xlsm”
Application.AutomationSecurity = 2 '恢复选择
End Sub