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

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.