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

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

--
Regards,
Dave


"csamms" wrote:

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

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

On Tue, 12 Sep 2006 12:10:02 -0700, csamms
wrote:

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