ExcelBanter - Go to sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Go to sheet (https://www.excelbanter.com/excel-discussion-misc-queries/246671-go-sheet.html)

Dear All,
In my excel file there are 20 to 30 sheets with the sheet names as Sheet1,
sheet2, and so on. Is there is any way to go to sheet directly i.e if I want
to go to sheet28 I have to go there by using mouse or Ctrl+Pg Dn
Thanks in advance

Hi,

Right click the fast forward/rewind control (To the left of the first
workshheet tab) and click the sheet name you want to go to.

Mike

"Vital_ar" wrote:

Dear All,
In my excel file there are 20 to 30 sheets with the sheet names as Sheet1,
sheet2, and so on. Is there is any way to go to sheet directly i.e if I want
to go to sheet28 I have to go there by using mouse or Ctrl+Pg Dn
Thanks in advance

If you click on one of the sheet navigation arrows at lower left you will
get a list of 15 sheets and "more"

You can build a Sheet Navigation Toolbar as per Dave Peterson's code on
Debra Dalgleish's site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Gord Dibben MS Excel MVP

On Tue, 27 Oct 2009 08:12:06 -0700, Vital_ar
wrote:

Dear All,
In my excel file there are 20 to 30 sheets with the sheet names as Sheet1,
sheet2, and so on. Is there is any way to go to sheet directly i.e if I want
to go to sheet28 I have to go there by using mouse or Ctrl+Pg Dn
Thanks in advance