#### golf4

##### Active Member
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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### RichardS

##### Well-known Member
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

##### Active Member
Thanks, Richard -

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

#### phantom1975

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

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

#### golf4

##### Active Member
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
enclosed is the vb code for the same

Best regards,
Zakir.

'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
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
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

Replies
12
Views
2K
Replies
15
Views
620
Replies
2
Views
446
Replies
1
Views
554
Replies
1
Views
593

1,181,309
Messages
5,929,217
Members
436,656
Latest member
ssims

### 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.

### Which adblocker are you using?

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

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