Expose hyperlinks

  • Thread starter Thread starter R
  • Start date Start date
R

R

Is there a way to show the underlying hyperlinks for a
group of cells at once?
 
Hi <insert missing name here>,

You can use a User Defined Function such as one of a few that you can
can find on my Build Table of Contents and Working with Hyperlinks page
http://www.mvps.org/dmcritchie/excel/builotoc.htm#url

Function HyperlinkAddress(cell)
On Error Resume Next
HyperlinkAddress = cell.Hyperlinks(1).Address
if hyperlinkaddress = 0 then hyperlinkaddress = ""
End Function

usage:
=HyperlinkAddress(A2)
=personal.xls!HyperlinkAddress(A2)

It is excellent for pasting your favorites into column A, and
having Column B show the actual url.

Instructions to install see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Bill Manville's solution, 2002-07-26, covers Excel links as well.
http://google.com/[email protected]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can UDF return a customized hyperlink? 3
Jeopardy on Powerpoint 0
Open specific hyperlink (accept) automatically in email with outlook 0
Can you hyperlink to a hyperlink? 1
Word hyperlink not showing once merged 0
Kiosk Mode Navigation 0
Excel Macro to hyperlink an archived worksheet to an index page 0
Hyperlink to named range in workbook 1

Back
Top