Forum Discussion

Copper Contributor

Apr 03, 2019

Keyboard shortcut to get a list of Excel sheets to select from

I have tried researching an answer to this question online in general and on this community board, but none that I found appear to apply to the Mac version of Excel 2019. I am trying to find the ...

Excel on Mac

Nauthstar

Iron Contributor

Apr 04, 2019

RSP123

Hi, I haven't tried this on a MAC before but you may be able to modify the below macro to get what you want working...

1. Create a macro (see below)

Private Sub Workbook_Open()
'Sub SheetMenu()
Application.CommandBars("Workbook tabs").ShowPopup
'End Sub
End Sub

2. Assign shortcut key combination to run it.

RSP123

Copper Contributor

Apr 04, 2019

Nauthstar

Thanks for the suggestion. I copied your algorithm into a Macro and get an error when I run it:

Run time error '28':

Out of stack space

I clicked to debug but can't identify the problem.

I'm not familiar with macros so don't know how I would edit this to make it work.

Nauthstar
Iron Contributor
Apr 05, 2019
Try...

Sub SheetMenu()
Application.CommandBars("Workbook tabs").ShowPopup
End Sub
- RSP123
  Copper Contributor
  Apr 06, 2019
  Nauthstar
  
  Thanks again for your suggestion. I didn't try it because I found the existing keyboard shortcut by trial and error. To bring up the list of sheets in Excel 2019, one Control clicks in the arrow box on the lower left where there are arrows to move right and left in the sheets. I thought this was not working when I tried it before; it appears that, for a workbook that has a lot of sheets (like mine with 75), sometimes it takes a few seconds before the list appears.
  - Nauthstar
    Iron Contributor
    Apr 08, 2019
    If you hold the Ctrl key down whilst you click on the bottom Left (or Right) arrow, it will quickly take you to the first (or last) tab in your spreadsheet. Handy if you have lots & lots of tabs.