Answers for "excel vba freeze panes without select"

VBA

1

excel vba freeze panes without select

'VBA routine to freeze the Excel window panes. No selection required:

Sub FreezePanes(row, col)
    With ActiveWindow
        If .FreezePanes Then .FreezePanes = 0
        .SplitRow = row
        .SplitColumn = col
        If row + col Then .FreezePanes = 1
    End With
End Sub

'-------------------------------------------------------------------
    
'Example usage:    
FreezePanes 3, 0

Posted by: Guest on March-30-2020

Source

Code answers related to "excel vba freeze panes without select"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#