Hyperlinks within a Workbook

[golf4]

Hi to everyone -

Thanks to everyone for the help on my past questions. One more please:

- still working on my income calculation spreadsheet, and I'm looking to insert hyperlinks to each of the individual worksheet pages. I tried the formula =hyperlink('sheet1'!) & =hyperlink('sheet1'!a1), and neither works. Any ideas?

Thanks again

 

[RichardS]

Not sure exactly how you do that, but ASAP utilities have an index utility which creates a sheet with hyperlinks to all the sheets in the book. Available at

http://www.asap-utilities.com

HTH

Richard

 

[golf4]

Thanks, Richard -

I went to the website referenced, but was unable to download anything.... ?

 

[phantom1975]

Hey there! You need to include the name of the workbook too!

=hyperlink("[Book1]Sheet1!A1","CLICK HERE")

Does this help?
This message was edited by phantom1975 on 2002-10-21 02:22

 

[golf4]

Hi, Richard -

Thanks for the help. I was finally able to download it. Thanks again.

Hi, Phantom -
Thanks for the help. Your suggestion worked great. Just had to rig the sheet names to call them "one" name, i,e, "tenant_rent" instead of "tenant rent". Once I did this, it worked great.

THANKS FOR THE CONTINUED ASSISTANCE!!!

 

[ZakirUlla]

enclosed is the vb code for the same

Best regards,
Zakir.

Sub Create_HyperLink_Index()
'Created by Zakir Ulla
Set NewSheet = ActiveSheet
For i = 1 To Sheets.Count
sheetnames = Sheets(i).Name
linkto = (sheetnames & "!" & "a1")
For m = 1 To 1
ActiveCell.Offset(1, 0).Range("a1").Select
ActiveCell.Hyperlinks.Add anchor:=Selection, Address:="", SubAddress:=linkto, _
ScreenTip:="Click to goto " & sheetnames, TextToDisplay:=sheetnames
Next m
Next i
ActiveCell.Select
Range(Selection, Selection.End(xlUp)).Select
With Selection
.Font.ColorIndex = 0
.Font.Underline = xlUnderlineStyleNone
End With
End Sub

I guess this could be more simpler, but it works!!!

On 2002-10-21 01:40, golf4 wrote:
Hi to everyone -

Thanks to everyone for the help on my past questions. One more please:

- still working on my income calculation spreadsheet, and I'm looking to insert hyperlinks to each of the individual worksheet pages. I tried the formula =hyperlink('sheet1'!) & =hyperlink('sheet1'!a1), and neither works. Any ideas?

Thanks again

This message was edited by ZakirUlla on 2002-10-22 09:52

 

[golf4]

Thanks for the help, everyone -

I was able to enter a lot of the hyperlinks between worksheets in my spreadsheet, but I think I now have a problem with compatability between the software version at home (EXCEL 2000) and the version at work (EXCEL XP).

On the version I have at home, I am able to move the curser over the hyperlink, press the Enter key and I would be in the other worksheet. I've e-mailed my home version to work, open it up here and the only way to activate the hyperlinks is to use my mouse and click on it - the Enter key will not work. I've tried messing with Tools-Options on the XP version, but I sill can't activate the hyperlinks via the Enter key.

Any suggestions?

Thanks