Shortcut key??
 

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)?

Shortcut key??
 

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)



"Brad" wrote in message
...
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)?