Showing Links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am wondering if there is any possible way to show all
the links that exist in a workbook. What I want is to be
able to see graphically, by simply looking at the
spreadsheet, which cells are linked and which are not,
rather than going through the sheet and trying to figure
this out cell by cell. Is there a way to do this? Does
anyone know?
 
Don't think there is a built in capability for it.

Are you talking about external links?

Anyway, you could probably write a macro that looks throught he spreadsheets
and colors the cells.
 
A similar discussion took place recently, and Earl K has posted a working
solution for the problem.

Here is his reply. After going through the post, you will know what to do.

Regards
Murthy

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

Paste the following User Defined Function into a general module:

Function GetFormula(RefCell As Range) As String
GetFormula = RefCell.Formula
End Function

Then use it in a cell

=GetFormula(A1)
=LEFT(GetFormula(A1), 3)

It should return ='C: as appropriate. And you can use it in conditional
formatting:

=LEFT(GetFormula(A1),4)="='C:"
 
The auditing toolbar will give you a quick graphical view.

Go to tools>auditing and then select show auditing toolbar.

Select a cell with a formula or a link and play with the buttons. you
should figure it out quickly.

That method only works for cell formulas.

If you are talking of hyperlinks, I would suggest that you use the
edit>links dialod in excel or something like Bill Manville's Find
Link.
You get it fairly quickly through Google.
 
Kieran,

Sorry, I repeated your comments about Bill Manville's FindLink. I hadn't
read your comment.

I did provide a URL, so I provided some tiny incremental value. :-)

Regards,
Kevin
 
Back
Top