Skip to main content

Freeze panes

Unfreezes panes, navigates the viewport to a target cell (A10), then refreezes panes at a different cell (D10).

(function () {
let worksheet = Api.GetActiveSheet();

// Step 1: Unfreeze panes so the view can scroll freely
worksheet.GetFreezePanes().Unfreeze();

// Step 2: Select the target cell
worksheet.GetRange("A10").Select();

// Step 3: Refreeze at D10
worksheet
.GetFreezePanes()
.FreezeAt(worksheet.GetRange("D10")); // The cell you want to freeze panes at
})();

Methods used: GetActiveSheet, GetFreezePanes, Unfreeze, GetRange, Select, FreezeAt

Reference Microsoft VBA macro code

Sub NavigateAndRefreeze()
ActiveWindow.FreezePanes = False
Application.Goto Reference:=Range("A10"), Scroll:=True
Range("D10").Select
ActiveWindow.FreezePanes = True
End Sub

Result

Freeze panesFreeze panes