Hyperlink

[Tarek]

Hi all,

I am trying to create an Index using hyperlinks within the sam
document. Such as:

Index
Transportation
Telecommunication



Transportation:
Automobile
Airplane
Spaceship

Top

Telecommuniation:
wireless phone
landline phone

Top

when clicking on "Transportation" (under "Index") a link will take yo
to the "transportation" at the bottom and if you click on "Top" lin
will take you to "Index"

Also to link how to use hyperlink to link a cell in a worksheet to tak
us to another cell in a different sheet withing the same workbook.


Cheers and thanks for your help,
Tare

 

[paritoshmehta]

Instead of the formula/function, have you tried creating a hyperlink
manually??, i.e. by right clicking on the cell and going to "hyperlink"
and then selecting "place in this document" and then selecting the
desired sheet and cell number??? as I create hyperlinks this way only
and it works absolutely fine for me!!!

 

[jeff]

Hi, Tarek,

(I'm using Excel 2002)

Say you have in cells A1:A3
Index
Transportation
Telecommunication

and in cell A36:A41, you have
Transportation:
Automobile
Airplane
Spaceship
(blank cell)
Top

Select "Transportation" in A2, go to
menu=Insert/hyperlink,
select "PLace in this document", and type in the cell
in "cell reference" = A36. click Ok
Do similar for your Telecommunication link (say, in
cell A80).

For both "Top"s, do the same thing, but select
A1 as "cell reference" (Index), so when "top" is
selected, you're taken to the top, Index.

You can also add some code like this below if you wish
to have the destination links scroll up (play with the
numbers) - right click on the tab, select "view code"
and insert:

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target = "Transportation:" Then ActiveWindow.ScrollRow
= 36
If Target = "Telecommunication:" Then
ActiveWindow.ScrollRow = 80
End Sub

 

[Tarek]

Thanks alot Jeff it worked perfectly, you have been a great help.

Best Regards,
Tare