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

W

WilmosLee

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
 
F

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

WilmosLee said:
Hi.. i hv 1 question to ask. Assume that i have more than 200
Click to expand...
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
Click to expand...
page, so when i click that button, it will go back to the first page,
or any better suggesstion?
 
P

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)



WilmosLee said:
Hi.. i hv 1 question to ask. Assume that i have more than 200 worksheet
Click to expand...
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
Click to expand...
when i click that button, it will go back to the first page, or any better
suggesstion?
 
D

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
[email protected]
WilmosLee said:
Hi.. i hv 1 question to ask. Assume that i have more than 200 worksheet
Click to expand...
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
Click to expand...
when i click that button, it will go back to the first page, or any better
suggesstion?
 
D

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
 
Top