hidden Hyperlink

E

expect_ed

If I copy an HTML page from IE and paste it into Excel (2003) the hyperlinks
from the page remain. But if I look at the cell contents/formula there is no
Hyperlink function shown. I can get the URL with a HyperlinkAddress function
as descibed here:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Function HyperlinkAddress(cell) As String
If cell.Hyperlinks.Count > 0 Then _
HyperlinkAddress = cell.Hyperlinks(1).Address
End Function

MY QUESTION: Is there a way for me to complete a cell so that the effect is
the same? i.e. the Hyperlink statement does not appear in the cell but
clicking in the cell still activates the link.

TIA
ed
 
D

Dave Peterson

Do you mean:

Insert|Hyperlink
(in xl2003 menus)
or ctrl-k

Or maybe...

Another way is to cover the cell with a rectangle (and hide the borders) and
assign a hyperlink to that invisible rectangle.
 

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

Top