| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlDialogs - Sheet Name List
When you right click on the 'next or previous' sheet arrows a list of sheet
names appears which enables the user to jump to a specific sheet or if there's a large amount of sheets then you have the option to view 'more sheets...' The dialog box that appears has the title of Activate, but there isn't a xlDialog called Activate. Can you tell me what it's called, or the code to actually show it? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
xlDialogs - Sheet Name List
Hi Trevor,
Try: Sub ShowSheetList() 'Based on code posted by Jim Rech On Error Resume Next If ActiveWorkbook.sheets.Count <= 16 Then Application.CommandBars("Workbook Tabs").ShowPopup 500, 225 Else Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute End If On Error GoTo 0 End Sub --- Regards, Norman "Trevor Williams" wrote in message ... When you right click on the 'next or previous' sheet arrows a list of sheet names appears which enables the user to jump to a specific sheet or if there's a large amount of sheets then you have the option to view 'more sheets...' The dialog box that appears has the title of Activate, but there isn't a xlDialog called Activate. Can you tell me what it's called, or the code to actually show it? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
xlDialogs - Sheet Name List
Thanks Norman, I'll give it a go.
Trevor "Norman Jones" wrote: Hi Trevor, Try: Sub ShowSheetList() 'Based on code posted by Jim Rech On Error Resume Next If ActiveWorkbook.sheets.Count <= 16 Then Application.CommandBars("Workbook Tabs").ShowPopup 500, 225 Else Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute End If On Error GoTo 0 End Sub --- Regards, Norman "Trevor Williams" wrote in message ... When you right click on the 'next or previous' sheet arrows a list of sheet names appears which enables the user to jump to a specific sheet or if there's a large amount of sheets then you have the option to view 'more sheets...' The dialog box that appears has the title of Activate, but there isn't a xlDialog called Activate. Can you tell me what it's called, or the code to actually show it? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
| Filter Range on Sheet B Based on List on Sheet A | Excel Discussion (Misc queries) | |||
| Selection from list on main sheet from suplemental sheet in same w | New Users to Excel | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
| adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) | |||
Linear Mode
