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

