remove all hyperlinks
 

I need code to remove all hyperlinks in a single sheet, not the whol
workbook, thanks

--
ski2004_200
-----------------------------------------------------------------------
ski2004_2005's Profile: http://www.excelforum.com/member.php...fo&userid=1641
View this thread: http://www.excelforum.com/showthread.php?threadid=37718

remove all hyperlinks
 

Select all the cells (ctrl-A (twice in xl2003))
hit alt-f11 (to get to the VBE, where macros live)
hit ctrl-g (to see the immediate window)

type this and hit enter:

selection.hyperlinks.delete

Close the VBE and back to excel to see if it worked.

===
You could even just select a smaller range and just clean that since the command
uses the current selection.

ski2004_2005 wrote:

I need code to remove all hyperlinks in a single sheet, not the whole
workbook, thanks.

--
ski2004_2005
------------------------------------------------------------------------
ski2004_2005's Profile: http://www.excelforum.com/member.php...o&userid=16418
View this thread: http://www.excelforum.com/showthread...hreadid=377182

--

Dave Peterson