Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Hyperlinks by column N Walton Excel Discussion (Misc queries) 0 July 17th 09 11:38 AM
how to plot column chart with one series against multiple series. svenkateshmurthy Charts and Charting in Excel 2 October 16th 07 09:09 PM
Can i "series fill" a number of cells with hyperlinks? Matt Excel Discussion (Misc queries) 1 February 3rd 06 02:19 PM
activate column of URLs as hyperlinks [email protected] Excel Discussion (Misc queries) 3 November 7th 05 09:03 PM
how do I change a line series to a column series in excel? Mati Charts and Charting in Excel 1 May 12th 05 09:32 AM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"