Freezing column headings

[Guest]

I'm trying to create a workbook in which the column headings and row headings
appear on all worksheets...how do I do that?

 

[Guest]

Select the cell beneath the row you want to freeze, and to the right of the
column you want to freeze and:

<Window>
<Freeze Panes>

 

[Gord Dibben]

Without doing each sheet manually..................

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("B2").Select
ActiveWindow.FreezePanes = True
End Sub


Gord Dibben MS Excel MVP