Go to Sheet

[Vital_ar]

Dear All,
It will be easy if there is any Key Board short Cut to go to a Specific Work
Sheet in a Work Book. For example i am working in a work book which contains
92 Sheets (in some times it will cross 122+ also). So every time I use mose
or Ctrl+PG Dn or Pg Up to go to that sheet. So if there is any option like go
to sheet such that i can directly go that specific sheet. (I am remebering
all the work sheet names in that work book so i can direclty go to that sheet
if any option is like that)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...0-ba5a707475d0&dg=microsoft.public.excel.misc

 

[Luke M]

2 options:
a) right click on one of the "go to end" sheet navigation arrows and use
that to pick the sheet you want

b) Press Ctl+G to bring up the goto dialogue. Simply type the name of your
sheet and add a dummy cell reference like:
'My Sheet'!A1

 

[Dave Peterson]

If you want a generic solution (good for any open workbook)...
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet. There's a link on that site for an xl2007 version for the ribbon
(from Ron de Bruin).

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)