View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.