I'm sure there's an easy answer to this...

  • Thread starter Thread starter Derek Biggs
  • Start date Start date
D

Derek Biggs

I'm a bit of a novice in Excel and wanted to do the
following:

I have several pages within a workbook (say sheet 1,2 & 3)
and a further page (information page). I want a user to be
able to link to the information page from any of the other
sheets.

Here's my problem - once the user has viewed the
information I want to set up a link back to the sheet they
came from. So if the user came from sheet 1 I want the
link to go back to sheet 1, if they came from sheet 2 then
I want to go back to sheet 2 etc.

I don't want to set a link to each individual sheet
because there's quite a few sheets and this will look
messy (there's about 40 other sheets and this info. sheet).

Hope someone can help - preferably without code but if it
has to be...

Thanks
 
You can name cell A1 on each sheet with a RangeName......(for testing I used
colors and colored the cells to make sure I was getting there.....Red, Blue,
Yellow, etc......), and then use the F5 Goto feature to jump back to
whatever sheet you want.......

Or, they can always just click on the proper sheet tab at the bottom of the
main window......

Vaya con Dios,
Chuck, CABGx3
 
Derek Biggs said:
I'm a bit of a novice in Excel and wanted to do the
following:

I have several pages within a workbook (say sheet 1,2 & 3)
and a further page (information page). I want a user to be
able to link to the information page from any of the other
sheets.

Here's my problem - once the user has viewed the
information I want to set up a link back to the sheet they
came from. So if the user came from sheet 1 I want the
link to go back to sheet 1, if they came from sheet 2 then
I want to go back to sheet 2 etc.

I don't want to set a link to each individual sheet
because there's quite a few sheets and this will look
messy (there's about 40 other sheets and this info. sheet).

Hope someone can help - preferably without code but if it
has to be...

Thanks
Click to expand...

Code it is!

-------------------------------------
Public Mysheet As String

Public Sub GoThere()
Mysheet = ActiveSheet.Name
Sheets("Info").Activate
End Sub

Public Sub GoBack()
Sheets(Mysheet).Activate
End Sub

------------------------------------

I suspect there are better ways of doing this, such as putting the info
stuff in a separate workbook with just one sheet. Then have both workbooks
open and let the user switch between them - use ctrl-F6.

Geoff
 
Back
Top