Auto Freeze Panes Macro. Freeze panes using vba. Rows 1 1 select activewindow freezepanes true freeze columns.
Range a a select activewindow freezepanes true. To freeze column a and row 1 at the same time select column b2 navigate to view freeze panes freeze panes. Sub freeze panes first ensure that no panes are frozen activewindow freezepanes false select the row that you want to freeze based on rows 3 3 select freeze panes activewindow freezepanes true end sub.
Similar to freeze panes in excel spreadsheet to freeze panes in excel vba select a cell first then set activewindow freezepanes property to true.
Range a a select activewindow freezepanes true. Freeze rows and columns. To freeze column a and row 1 at the same time select column b2 navigate to view freeze panes freeze panes. Range b2 select activewindow freezepanes true.
