Printing a list of Worksheet Tabs

  • Thread starter Thread starter P clark
  • Start date Start date
P

P clark

Is there a way to print a list of worksheet titles within
a workbook? All I need is the list of titles, not the
documents themselves. We have several large workbooks
with numerous worksheets and would like to be able to
view a list containing the Titles listed on each TAB
easily. Your response is appreciated. Thank you!
 
Hi P Clark!

Apart from Frank's reference, are you aware that a right click on any
of four buttons to the left of the sheet tabs will bring up a list of
the worksheets. If there are more than about 12, this is scrollable.
If you click on a sheet, it takes you right there.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Or if you want them on paper

It will add a sheet to your workbook and add the sheetnames
Then print and delete the sheet.

Sub PrintTabNames()
Application.ScreenUpdating = False
Dim Nsheet As Worksheet
Set Nsheet = Sheets.Add
Dim WS As Worksheet
Dim r As Integer
r = 1
For Each WS In Worksheets
If WS.Name <> Nsheet.Name Then
Nsheet.Range("A" & r) = WS.Name
r = r + 1
End If
Next WS
Nsheet.PrintOut
Application.DisplayAlerts = False
Nsheet.Delete
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
 
Back
Top