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

为不同的效果选择不同的范围，与手动方式大致相同。 冻结顶行真的只是Excel 2007（及以上）中的一个快捷方式，与早期版本的Excel相比，它不包含添加的功能。

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.