Shortcut key??

[Guest]

In Excel 2003 or 2007, there are four buttons(arrows) in the lower left
corner, that allow the user to toggle between sheets. If you right click the
mouse (on this area), a listing of all the sheets appears. Is there any way
that you can get the listing of the sheets, just by using the keyboard (not
using the mouse)?

 

[Chip Pearson]

I don't think there is a built in shortcut key, but you could assign the
following code to the key of your choice:

Sub ShowTabList()
Application.CommandBars("Workbook Tabs").ShowPopup
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)