I was trying to freeze the first row of each sheet besides the first sheet. Can someone help me find a way to skip the first sheet in this loop?
Public Sub FreezePanes() Dim s As Worksheet Dim c As Worksheet '// store current sheet Set c = ActiveSheet '// Stop flickering... Application.ScreenUpdating = False '// Loop throught the sheets For Each s In ThisWorkbook.Worksheets '// Have to activate - SplitColumn and SplitRow are properties '// of ActiveSheet s.Activate With ActiveWindow .SplitColumn = 0 .SplitRow = 1 .FreezePanes = True End With Next '// Back to original sheet c.Activate Application.ScreenUpdating = True Set s = Nothing Set c = Nothing End Sub




Reply With Quote