Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add in that shows names of tabs in workbook
I belief that there was a add-in that would show the names of tab in a
workbook. You could click on the name and it would take you to that tab. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add in that shows names of tabs in workbook
Try this:
Right-click on the tab navigation arrows (in the lower left of the Excel window and to the left of the tabs). That will display a list of the tab names. Clicking one will take you to that tab. Is that what you're referring to? *********** Regards, Ron XL2002, WinXP "Rod" wrote: I belief that there was a add-in that would show the names of tab in a workbook. You could click on the name and it would take you to that tab. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add in that shows names of tabs in workbook
There are many different versions of VBA code used that can give you a
selectable list of sheet tabs. You could place that code in an Add-in if you chose to do so. I like Bob Phillips' browsesheets macro. I have tested it with up to 150 sheets in a workbook. Sub BrowseSheets() Const nPerColumn As Long = 38 'number of items per column Const nWidth As Long = 13 'width of each letter Const nHeight As Long = 18 'height of each row Const sID As String = "___SheetGoto" 'name of dialog sheet Const kCaption As String = " Select sheet to goto" 'dialog caption Dim i As Long Dim TopPos As Long Dim iBooks As Long Dim cCols As Long Dim cLetters As Long Dim cMaxLetters As Long Dim cLeft As Long Dim thisDlg As DialogSheet Dim CurrentSheet As Worksheet Dim cb As OptionButton Application.ScreenUpdating = False If ActiveWorkbook.ProtectStructure Then MsgBox "Workbook is protected.", vbCritical Exit Sub End If On Error Resume Next Application.DisplayAlerts = False ActiveWorkbook.DialogSheets(sID).Delete Application.DisplayAlerts = True On Error GoTo 0 Set CurrentSheet = ActiveSheet Set thisDlg = ActiveWorkbook.DialogSheets.Add With thisDlg .Name = sID .Visible = xlSheetHidden 'sets variables for positioning on dialog iBooks = 0 cCols = 0 cMaxLetters = 0 cLeft = 78 TopPos = 40 For i = 1 To ActiveWorkbook.Worksheets.Count If i Mod nPerColumn = 1 Then cCols = cCols + 1 TopPos = 40 cLeft = cLeft + (cMaxLetters * nWidth) cMaxLetters = 0 End If Set CurrentSheet = ActiveWorkbook.Worksheets(i) cLetters = Len(CurrentSheet.Name) If cLetters cMaxLetters Then cMaxLetters = cLetters End If iBooks = iBooks + 1 .OptionButtons.Add cLeft, TopPos, cLetters * nWidth, 16.5 .OptionButtons(iBooks).text = _ ActiveWorkbook.Worksheets(iBooks).Name TopPos = TopPos + 13 Next i .Buttons.Left = cLeft + (cMaxLetters * nWidth) + 24 CurrentSheet.Activate With .DialogFrame .Height = Application.Max(68, _ Application.Min(iBooks, nPerColumn) * nHeight + 10) .Width = cLeft + (cMaxLetters * nWidth) + 24 .Caption = kCaption End With .Buttons("Button 2").BringToFront .Buttons("Button 3").BringToFront Application.ScreenUpdating = True If .Show Then For Each cb In thisDlg.OptionButtons If cb.Value = xlOn Then ActiveWorkbook.Worksheets(cb.Caption).Select Exit For End If Next cb Else MsgBox "Nothing selected" End If Application.DisplayAlerts = False .Delete End With End Sub Gord Dibben MS Excel MVP On Tue, 12 Sep 2006 11:32:02 -0700, Rod wrote: I belief that there was a add-in that would show the names of tab in a workbook. You could click on the name and it would take you to that tab. Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add in that shows names of tabs in workbook
There are probably millions of these.
And this is one: http://contextures.com/xlToolbar01.html From Debra Dalgleish's site. Rod wrote: I belief that there was a add-in that would show the names of tab in a workbook. You could click on the name and it would take you to that tab. -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add in that shows names of tabs in workbook
Excel Extras at ... http://www.realezsites.com/bus/primitivesoftware
-- Jim Cone San Francisco, USA "Rod" wrote in message I belief that there was a add-in that would show the names of tab in a workbook. You could click on the name and it would take you to that tab. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook tabs | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Enter a customer name in the invoice workbook when the names are . | Excel Worksheet Functions | |||
Excel opens saved workbook without tabs or scroll bars showing? | Excel Worksheet Functions | |||
Workbook Tabs | Excel Discussion (Misc queries) |