This pdf has a macro that will do that:
http://www.nesug.org/html/Proceeding...04/po/po07.pdf
The macro is
Sub worksheet_names()
Dim WS As Worksheet
Sheets.Add.Name = "Worksheet_Names"
For Each WS In Worksheets
Cells(WS.Index, 1).Value = WS.Name
Next WS
End Sub
It will create a worksheet named "Worksheet_Names" and put the worksheet
names on it.
"Jugglertwo" wrote:
Is there any way to print the names of the spreadsheet tabs in a workbook?
I would like to print a list of the 50 worksheet tabs that I have in my
workbook to a paper.
It would be ideal if the list could be produced on another spreadsheet in
this same workbook.
Any suggestions would be greatly appreciated !
Thanks !
Tim