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

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

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