1、打开一个含有VBA功能的工作簿,若是Excel没有启用宏,会在Excel工作簿的状态栏上有提示“安全警告,宏已被禁用。启用内容”如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2e2eb9389b504fc221a706e5ebdde71191ef6d52?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击工作簿左上方的“文件”按钮,弹出如下图所示的界面后,单击“选项“按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4e4a20a4462309f73baf1bf27c0e0cf3d6cad60a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、之后,弹出“Excel选项“对话框, 单击“信任中心“按钮,点击“信任中心设置“按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9213b07eca806538dad715f399dda144ad348215?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、此时,弹出“信任中心“对话框,在其下属菜单中选择”宏设置“菜单,并单击。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800a03583feebf3533fa838b4794?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、接着,弹出“宏设置“的详细内容,在宏设置下,勾选”启用所有宏“,点击确定按钮。此时,在EXCEL中成功启用宏。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd5e8a25f145fda81cb38db3d58?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、以上操作完成之后,回到工作簿界面,按“Alt+F8”,组合键,即可调用宏。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8435e5dde71190ef8eea233fc01b9d16fdfa6039?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)