1、打开EXCEL表格。单击左上角“文件”,下拉到底部选择“更多-选项”。
2、设置信任中心。左侧点击“信任中心”,右侧单击“信任中心设置”按钮。
3、点击宏设置。弹出窗口,左侧点击“宏设置”,右侧勾选“启用所有宏”和“信任对VBA工程对象模型的访问”。
4、点击视图。点击确定,返回工作表里,点击菜单栏上“视图”,单击宏,下拉选择“录制宏”即可启用宏功能。

1, open EXCEL table. Click top left corner " file " , bottom option is played below " more - option " .
2, set trustful center. Left click " trustful center " , click on the right side of " trustful center is installed " pushbutton.
3, click grand setting. Play a window, left click " grand setting " , tick off on the right side of anthology " enable all grand " and " accredit is right the visit of model of VBA project object " .
4, click view. Click affirmatory, return working the outside and the inside, click menu column to go up " view " , click grand, the option is played below " transcribe grand " can enable grand function.