Is there a shortcut to removing the hyperlinks in a column so that there is only text?
C coastal Jun 25, 2007 #1 Is there a shortcut to removing the hyperlinks in a column so that there is only text?
D Dave Peterson Jun 25, 2007 #2 Select the column. Alt-F11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: selection.hyperlinks.delete
Select the column. Alt-F11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: selection.hyperlinks.delete
G Gord Dibben Jun 25, 2007 #3 Copy an empty cell. Select the column of hyperlink cells and Paste Special>Add>OK>Esc David McRitchie has code and more suggestion for dealing with hyperlinks. http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks Gord Dibben MS Excel MVP
Copy an empty cell. Select the column of hyperlink cells and Paste Special>Add>OK>Esc David McRitchie has code and more suggestion for dealing with hyperlinks. http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks Gord Dibben MS Excel MVP
