#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 846
Default 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)?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default 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)?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut to : key Margaret RM Excel Discussion (Misc queries) 4 July 12th 07 03:27 AM
shortcut Dev Excel Discussion (Misc queries) 1 March 7th 07 07:05 PM
Shortcut Daniel - Sydney Excel Discussion (Misc queries) 4 November 23rd 05 10:56 PM
Shortcut key help Trying2Learn Excel Discussion (Misc queries) 1 October 5th 05 03:12 PM
Shortcut into Name box Bonnie Excel Discussion (Misc queries) 2 March 4th 05 03:27 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"