Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jugglertwo
 
Posts: n/a
Default 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   Report Post  
Barb R.
 
Posts: n/a
Default



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   Report Post  
Norman Jones
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet Tabs at bottom of Workbook csfrolich Excel Discussion (Misc queries) 1 April 1st 05 07:21 PM
How can you print file properties in an Excel spreadsheet? RSG Excel Discussion (Misc queries) 1 February 21st 05 09:33 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 08:01 PM
Autoshapes not visible on spreadsheet but visible in print preview John Excel Discussion (Misc queries) 3 February 11th 05 11:23 PM
create a drop down list with the source from a different workbook Sampath Excel Discussion (Misc queries) 2 January 8th 05 08:57 PM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"