Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Hyperlinks | Links and Linking in Excel | |||
How to remove multiple hyperlinks at once | Excel Worksheet Functions | |||
Remove hyperlinks | Excel Discussion (Misc queries) | |||
How do I remove hyperlinks | Excel Discussion (Misc queries) | |||
remove hyperlinks | Excel Discussion (Misc queries) |