Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to print out the sheet tabs (sheet names)
Dear Sirs,
I work daily on excel and lately I needed to view my sheet tabs all at once so I wamted to print them out and I did not know how? |
#2
|
|||
|
|||
Hi
You can use an UDF. The one below returns tab name from tab's index (order number) --------- Public Function TabByIndex(TabIndex As Integer) As String Application.Volatile TabByIndex = Sheets(TabIndex).Name End Function --------- P.e. =TABBYINDEX(3) returns the name of 3th sheet in your workbook Arvi Laanemets "Sundus" wrote in message ... Dear Sirs, I work daily on excel and lately I needed to view my sheet tabs all at once so I wamted to print them out and I did not know how? |
#3
|
|||
|
|||
On Wed, 23 Feb 2005 10:47:05 -0800, Sundus
wrote: Dear Sirs, I work daily on excel and lately I needed to view my sheet tabs all at once so I wamted to print them out and I did not know how? I use a Free utility from ASAP-Uitlities.com. They have a function that will create an index sheet and even hyperlink to each one. You could print that sheet, if you needed a hard copy. Don S |
#4
|
|||
|
|||
Sundus
Private Sub ListSheets() 'list of sheet names starting at A1 on an inserted new sheet. 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 If not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm In the meantime.......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. The macro can be assigned to a button or shortcut-key combo. Gord Dibben Excel MVP On Wed, 23 Feb 2005 10:47:05 -0800, Sundus wrote: Dear Sirs, I work daily on excel and lately I needed to view my sheet tabs all at once so I wamted to print them out and I did not know how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
how do i print a column containing 150 names on 1 sheet of paper . | Excel Discussion (Misc queries) | |||
Setting up a macro to print? | Excel Worksheet Functions | |||
How do I change the font color of my sheet tabs? | Excel Discussion (Misc queries) | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |