Freeze Pane Macro
 

Is there a macro that can freeze pane after the first row in all active
sheets except for worksheet "Tracker".

Any help would be greatly appreciated. I tried selecting ALL worksheets
except for tracker... Did freeze pane and it only applied to the first tab.
Is this normal?

Freeze Pane Macro
 

Sub freeze()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Name < "Tracker" Then
ws.Activate
ActiveSheet.Range("B2").Select
ActiveWindow.FreezePanes = True
End If
Next ws
End Sub


Gord Dibben MS Excel MVP

On Mon, 14 Apr 2008 17:11:01 -0700, simplymidori
wrote:

Is there a macro that can freeze pane after the first row in all active
sheets except for worksheet "Tracker".

Any help would be greatly appreciated. I tried selecting ALL worksheets
except for tracker... Did freeze pane and it only applied to the first tab.
Is this normal?