Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying Hyperlinks by column | Excel Discussion (Misc queries) | |||
how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
Can i "series fill" a number of cells with hyperlinks? | Excel Discussion (Misc queries) | |||
activate column of URLs as hyperlinks | Excel Discussion (Misc queries) | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |