How to Freeze Panes at a Specific sheet

[9kitti]

I have 5 main sheets and want to freeze pane lines starting from sheet 6, row 7, column 2. What do I have to do? Thank you.

 

[myall_blues]

Freeze panes is independent from one sheet to the next, so you can have freeze panes not set for sheets 1-5 and then set it for sheet 6 and onward to wherever you want it to be. Unfortunately you cannot select a group of sheets and set them all the same, as far as I know, so they need to be done individually.

Regards

Murray

 

[9kitti]

Freeze panes is independent from one sheet to the next, so you can have freeze panes not set for sheets 1-5 and then set it for sheet 6 and onward to wherever you want it to be. Unfortunately you cannot select a group of sheets and set them all the same, as far as I know, so they need to be done individually.

Regards

Murray

i use this code but error

Sub moFreeze()
    Dim sh As Worksheet
    Application.DisplayAlerts = False
    For Each sh In Worksheets
        If sh.Index > 5 Then
            'With Sheets("Main")
            With sh
          If .FreezePanes Then .FreezePanes = False
            .SplitColumn = 2
            .SplitRow = 7
            .FreezePanes = True
                End With
            End If
        End If
    Next sh
   Application.DisplayAlerts = True
End Sub

 

[myall_blues]

Try this instead.

Sub moFreeze()
    Dim sh As Worksheet
    Application.DisplayAlerts = False
    For Each sh In Worksheets
        If sh.Index > 5 Then
            sh.Activate
            With ActiveWindow
                If .FreezePanes Then .FreezePanes = False
                .SplitColumn = 2
                .SplitRow = 7
                .FreezePanes = True
            End With
        End If
    Next sh
   Application.DisplayAlerts = True
End Sub

Regards

Murray

 

[9kitti]

Thank you. It is my boss's wish. You saved my life a lot. Thank you very much.

 

[myall_blues]

You’re welcome. Thanks for the feedback.