Answered by : witty-wren-lrc0b9xibtkt

With ActiveWindow .SplitColumn = 0 .SplitRow = 1
End With
ActiveWindow.FreezePanes = True

Source : https://stackoverflow.com/questions/3232920/how-can-i-programmatically-freeze-the-top-row-of-an-excel-worksheet-in-excel-200 | Last Update : Sun, 13 Dec 20