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
 
Ad

Advertisements

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