Keyboard Shortcut to View all Worksheets (Excel 2010)

[peteradamsims]

Hi,

Is there a keyboard shortcut to view all the worksheets in a workbook? I know how to right click on the <> arrows to view all the worksheets but wondered if there was a shortcut?

Thanks

Peter

 

[peteradamsims]

No problem.

I guess there isn't a way to write a macro to do it or create a formula (by replacing with a less used keyboard shortcut)?

I meant *or create a new shortcut*, not formula

 

[Fluff]

It would be possible with a macro, but you would need to create a userform, with a listbox & all the relevant code.
Which seems a bit of overkill, just to avoid using the right click.

EDIT:
Ignore this, I was wrong. See post below.

 

[RoryA]

You can use:

application.CommandBars("Workbook tabs").ShowPopup

in a macro.