Excel pictured hyperlink as "normal" cell content

B

bendes

Hi,

In an Excel sheet the cells in a column contain hyperlinks(http:/
....)covered by a picture, but they seem to be empty. The reference
popups only, when I point to each cell with the cursor.
How can I convert multiple cells' hyperlinks contents as a "simple
hyperlink text, by few step? (the cell will contain the hl as genera
underscored(text) only, instead of picture or "blank" cell)

Thanks

S.Yours
bendes

P.S. As you see, I am not an expert..

Attachment filename: hyperlink_example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53296
 
D

David McRitchie

Hi bendes,
Why do you say that the cells seem to be empty when
you created the hyperlinks yourself not within the cells
but within the pictures.

You will have to use a programming solution, specifically
a macro.

If you want to transfer the link to the cell to the right of each
picture you can cycle through the shapes on the page.
#ExtractLinkToRightOfShapes from a posting by Dick Kusleika
http://www.mvps.org/dmcritchie/excel/excel.htm#ExtractLinkToRightOfShapes

If you then want to remove the shapes you can do that
with one instruction. But you can use extra code to
make sure things work well if you run the macro by itself see
delShapesOnSht macro by Dave Peterson
http://www.mvps.org/dmcritchie/excel/shapes.htm

As indicated at the top of that page: If you need assistance
to install or to use a macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top