ActiveWindow.FreezePanes = False Use Split to freeze Panes in Excel VBA To unfreeze panes, simply set the FreezePanes Property to False. To freeze column A and row 1, select Cell B2. FreezePanes won’t work if there is already a FreezePanes. Setting FreezePanes to False is to ensure that we have unfrozen any active freezePanes first. Similar to freeze panes in Excel spreadsheet, to freeze panes in Excel VBA, select a Cell first, then set ActiveWindow.FreezePanes Property to TRUE. In the screenshot, I have highlighted the direction of freeze of a selected cell, it is the top row and left column of a selected Cell. To freeze column A and row 1 at the same time, select column B2, navigate to View > Freeze Panes > Freeze Panes Similarly, you can freeze column A and B by highlighting column C (highlight the right column of the target frozen column). To display data all the time in column A when you scroll to the right of the spreadsheet, highlight column B,, navigate to View > Freeze Panes > Freeze Panes Similarly, you can freeze row 2 by highlighting row 3 (highlight one row down the frozen row).
![shut off freeze frame in excel shut off freeze frame in excel](https://images.tips.net/S22/Figs/T12139F1.png)
Highlight row 2, navigate to View > Freeze Panes > Freeze Panes So that when you scroll down the spreadsheet, you can still see the header in row 1.
![shut off freeze frame in excel shut off freeze frame in excel](https://www.digiruns.com/wp-content/uploads/2019/04/Freeze-Panes.png)
The most common kind of freeze panes is to freeze the first row as it contains the header of the column.
Shut off freeze frame in excel how to#
To explain how to freeze panes in Excel VBA, first I have to explain how to freeze panes in Excel spreadsheet. This Excel tutorial explains how to freeze panes in Excel spreadsheet and freeze panes in Excel VBA using FreezePanes property.