Hyperlinks within a Workbook

golf4

Active Member
Joined
Jul 8, 2002
Messages
452
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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

golf4

Active Member
Joined
Jul 8, 2002
Messages
452
Thanks, Richard -

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

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
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

Active Member
Joined
Jul 8, 2002
Messages
452

ADVERTISEMENT

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

New Member
Joined
Oct 21, 2002
Messages
1
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

Active Member
Joined
Jul 8, 2002
Messages
452
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
 

Forum statistics

Threads
1,144,274
Messages
5,723,444
Members
422,497
Latest member
dougy99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top