ActiveWindow.FreezePanes = Not ActiveWindow.FreezePanes
End Sub '代码功能是,点击一下该过程,就冻结;再点击一次,就取消冻结。是一种循环冻结或取消的代码。
②代码
Activwindow.FreezePanes=true
'代码功能是:冻结Excel窗口;如果要取消,就必须使用菜单的操作,才能取消。
③代码
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveWindow.SplitRow = 2 And ActiveWindow.SplitColumn = 1 Then Exit Sub ActiveWindow.SplitRow = 2 ActiveWindow.SplitColumn = 1 ActiveWindow.FreezePanes = True End Sub