How can I programmatically freeze the top row of an Excel worksheet in Excel 2007 VBA?

Rows("2:2").Select
ActiveWindow.FreezePanes = True

Select a different range for a different effect, much the same way you would do manually. The “Freeze Top Row” really just is a shortcut new in Excel 2007 (and up), it contains no added functionality compared to earlier versions of Excel.