excel宏不能录制-excel宏无法录制,excel录制宏有什么用

excel选项-加载项-管理-禁用项目，点击转到，选择personal.xlsb-启动

看截图你用的应该是WPS个人版，这是没有VBA模块的。
一是从网上下载安装相应的VBA模块
一是安装微软的OFFICE
可以设置的，我录制的下面的使用没有问题
只要修改range括号里的区域就能设置边框为黄e799bee5baa6e997aee7ad94e78988e69d83363色了

Range("D6:E9").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 6
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 6
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 6
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 6
End With
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone

正常版本的EXCEL点宏里面的录制就可以，如果你是安装的是精简版或者WPS，可能不支持，无法录制，也无法运行。