Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Print Spreadsheet tabs in a Workbook to a List?
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Hi Jugglertwo,
You might also look at David McRitchie's 'Build Table of Contents' page at: http://www.mvps.org/dmcritchie/excel/buildtoc.htm --- Regards, Norman "Jugglertwo" wrote in message ... 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 |
#4
|
|||
|
|||
Tim
Macro ok? ''list of sheet names in a workbook - placed on a new worksheet Sub ShowNames() Set wkbkToCount = ActiveWorkbook iRow = 1 With Sheets.Add For Each ws In wkbkToCount.Worksheets .Rows(iRow).Cells(1).Value = ws.Name iRow = iRow + 1 Next End With End Sub Gord Dibben Excel MVP On Fri, 27 May 2005 09:45:14 -0700, "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Tabs at bottom of Workbook | Excel Discussion (Misc queries) | |||
How can you print file properties in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) |