How to go back from 350 worksheet to the first worksheet in 1 file

[Guest]

Hi.. i hv 1 question to ask. Assume that i have more than 200 worksheet into 1 excel file, so imaging that i need to go back to the first worksheet from 350 page.
So how should i do?
Can i add the button like 'GO BACK TO FIRST PAGE' inside the 350 page, so when i click that button, it will go back to the first page, or any better suggesstion?
Thanks in advanced.

Regards,
Wilmos Lee

 

[Frank Kabel]

Hi
try right-clicking with your mosue on the sheet navigation buttons in
the lower left corner of your workbook. This should open a list of all
your worksheets

--
Regards
Frank Kabel
Frankfurt, Germany

Hi.. i hv 1 question to ask. Assume that i have more than 200

worksheet into 1 excel file, so imaging that i need to go back to the
first worksheet from 350 page.

So how should i do?
Can i add the button like 'GO BACK TO FIRST PAGE' inside the 350

page, so when i click that button, it will go back to the first page,
or any better suggesstion?

 

[Peo Sjoblom]

Press F5, put the address where you want to go e.g. Sheet1!A1, press enter,
while doing this
record a macro (tools>macro>record new macro, this workbook click OK), stop
the macro,
pull down a button from the forms toolbar (view>toolbars>forms), drag it
unto the sheet and
when you release the mouse you can assign your macro to it. This is a rather
crude way and it won't work if
you insert a sheet before the sheet you recorded in your macro. Post back if
you need something else

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Hi.. i hv 1 question to ask. Assume that i have more than 200 worksheet

into 1 excel file, so imaging that i need to go back to the first worksheet
from 350 page.

So how should i do?
Can i add the button like 'GO BACK TO FIRST PAGE' inside the 350 page, so

when i click that button, it will go back to the first page, or any better
suggesstion?

 

[Don Guillett]

If you don't need it for anything else you could put this in your
ThisWorkbook module

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target
As Range, Cancel As Boolean)
Application.Goto Sheets(1).Range("A1")
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi.. i hv 1 question to ask. Assume that i have more than 200 worksheet

into 1 excel file, so imaging that i need to go back to the first worksheet
from 350 page.

So how should i do?
Can i add the button like 'GO BACK TO FIRST PAGE' inside the 350 page, so

when i click that button, it will go back to the first page, or any better
suggesstion?

 

[Dave Peterson]

And just to piggyback on Peo's idea.

Define a name that points at the cell on sheet1. Then you can hit F5 and type
it in. Or even just type the name into the namebox (to the left of the
formulabar).

Or add a hyperlink to a cell of each sheet that points back at sheet1!a1.
Kind of like this:
=HYPERLINK("#"&CELL("address",Sheet1!A1),"Table of contents")

So now each sheet has a link to a "table of contents" sheet.

Now use the code at David McRitchie's site to build that table of contents
(Links to all the other sheets).
http://www.mvps.org/dmcritchie/excel/buildtoc.htm