Bringing up worksheet activation list Excel 2013

[exceluser888]

I know that I can right click on the arrows to the left of the worksheet tabs to bring up the list of worksheets in a workbook, and then select one to activate. I'm wondering if there is a way to open this list using a keyboard shortcut. I have searched quite a bit and I have not found a way to do this. It would save me quite a bit of time, because I am often switching between worksheets in large excel files where ctrl+pg up/down is not efficient, so I have to use my mouse to right click and bring up this list.

 

[wigi]

Hello

For example:

Sub Wigi()
   [COLOR=#000000]Application.CommandBars("workbook tabs").ShowPopup
End Sub[/COLOR]

 

[My Aswer Is This]

Wigi:
I've never heard of this command before. It does work. Where can I read more about this command. I did a Google search and cannot find much. Can it be used for other commands?

 

[My Aswer Is This]

I created this script but Wigi has a better ideal.

Sub Activate_Sheet()
For i = 1 To Worksheets.Count
UserForm1.ListBox1.AddItem Worksheets(i).Name
Next
UserForm1.Show
End Sub

 

[wigi]

Hi

Here's a page listing other similar commands:
List of ID numbers for built-in CommandBar controls in Excel 2000

 

[Rick Rothstein]

I know that I can right click on the arrows to the left of the worksheet tabs to bring up the list of worksheets in a workbook, and then select one to activate. I'm wondering if there is a way to open this list using a keyboard shortcut. I have searched quite a bit and I have not found a way to do this.

You might find the following mini-article of mine to be of interest...

<!-- title / author block --> A Neat "Go To Sheet" Selector

 

[My Aswer Is This]

Thanks Wigi and Rick. I will take a look. You can learn something here every day.