切记:excel文件如果比较大的情况下,一定要用MS打开,而不要用wps,wps在处理大文件时非常不稳定!!!
excel 冻结全部工作表的宏代码:
Sub 冻结首行()
Dim oWS As Worksheet
For Each oWS In Worksheets
oWS.Activate
With Application.ActiveWindow
.SplitRow = 1
.FreezePanes = True
End With
Next
End Sub
参考:http://www.exceltip.net/thread-32768-1-1.html