Hyperlink

  • Thread starter Thread starter Wetware
  • Start date Start date
W

Wetware

I was wondering if any of you could help me with a problem.
i got a sheet to manage other sheets i want to hyperlink all my sheets
But i want it automated.

My column A as the sheet name and the last column as the link.
I want to be able to add a new name and the link is generated
after the name as be entered.

anyone can help ?

thank you in advanc
 
-----Original Message-----

I was wondering if any of you could help me with a problem.
i got a sheet to manage other sheets i want to hyperlink all my sheets.
But i want it automated.

My column A as the sheet name and the last column as the link.
I want to be able to add a new name and the link is generated
after the name as be entered.

anyone can help ?

thank you in advance


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

.
You can do this programatically using VBA. When you say
Click to expand...
I have a sheet to manage all the other sheets are you
using it as a table of contents to refer to the other
sheets?

This can definetly be done but may be a paying kind of
deal.

Thanks,

Greg
 
is it not possible to just give the content of a cell to the link
example:

A1 is job-001
and at G1 i want to link to a file that is job-001.xls.

that's all i need...

thank you in advanc
 
Since it seems you already have the parts you need on the row
you can use the HYPERLINK Worksheet Function.

You did not include the pathname, sheetname in what you have. Take a look at
Worksheets in VBA Coding and in Worksheet Formulas
Coding a link address and friendly name using HYPERLINK Worksheet function (#hyperlink)
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink

=HYPERLINK("[c:\temp folder\" & A1 & ".xls]'Sheet One'!$C$5","Sheet One")

=HYPERLINK("c:\temp folder\" & A1 & ".xls","link to " & A1)

=HYPERLINK("c:\temp folder\" & A1 & ".xls","[x]") -- or just something to mean a link

Answered in the newsgroup microsoft.public.excel.worksheet.functions which
has nothing to do with the indirect web interface ExcelForum.
 
Back
Top