Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HYPERLINK function
Can someone help me understand this function's syntax?
Here's the situation: I have a workbook with a dozen tabs. I want to create a thirteenth tab, called INDEX, which has hyperlinks to A1 of each tab. If the first tab of my workbook is called Sheet1, I want the user to be able to click on a link in the INDEX tab which takes him to cell A1 of Sheet1. If I think of this in HTML terms, what I'm looking to do is something like <a href="http://www.cnn.com/"Click here to go to CNN</a where the "friendly" name 'click here to go to CNN' is a live link that takes you to CNN.com. Possible? I think so. I'm using XL 2000 if that matters. Thanks for your help. -- Brevity is the soul of wit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pls add browse button for Hyperlink function | Excel Worksheet Functions | |||
character limit in hyperlink function | Excel Worksheet Functions | |||
How to setup a hyperlink to an indirect function? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Hyperlink Function not working as expected | Excel Discussion (Misc queries) |