view list of worksheets contained within a workbook
 

how do i view list of worksheets contained within a workbook in excell?

Right click one of the sheet tab arrows at the left hand side
Only other option is to us VBA (macro)

--

Regards,

Peo Sjoblom

"michael" wrote in message
...
how do i view list of worksheets contained within a workbook in excell?

A macro to list the sheets on a new worksheet.

Private Sub ListSheets()
'list of sheet names starting at A1
Dim Sh As Worksheet
Dim Rng As Range
Dim i As Integer
Worksheets.Add
Set Rng = Range("A1")
For Each Sh In ActiveWorkbook.Sheets
Rng.Offset(i, 0).Value = Sh.Name
i = i + 1
Next Sh
End Sub


Gord Dibben Excel MVP

On Tue, 22 Feb 2005 06:31:03 -0800, "michael"
wrote:

how do i view list of worksheets contained within a workbook in excell?

"michael" wrote:

how do i view list of worksheets contained within a workbook in excel?

You can also click on "File", drop to "Properties" and then click on the
"Contents" tab to see the list of worksheets