View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default How do I get rid of a series of hyperlinks in a column or row

hi
paste this into a standard module. high the hyperlinks and run.
it will remove on the the hyperlinks, leaving the text.
Sub removehyperlink()
Selection.Hyperlinks.Delete
End Sub

if you are new to macros, see this site
http://www.mvps.org/dmcritchie/excel/getstarted.htm

regards
FSt1

"SodaFried" wrote:

How to I get rid of a series of hyperlinks in a column or row with embedded
pictures or graphics leaving the text behind? I only want the text or numbers
left on spreadsheet.

The instructions only cover a single hyperlink and are vague from there on
and require multiple steps.

--
Howdy