eliminating hyperlinks from a complete column in Excel

[childofthe1980s]

Hello:

Do you know how to eliminate hyperlinks, for all cells from within a column
in Excel? I know how to do it by cell but not by column.

childofthe1980s

 

[JLatham]

I'm not sure you can get there directly through keyboard commands, but this
code will do it:

Sub RemoveManyHyperlinks()
'select the column or row or group of cells
'that you want to remove hyperlinks from
'and then, with them selected, use
'Tools | Macro | Macros
'to select this macro and click the
'[Run] button to kiss them bye-bye
Selection.Hyperlinks.Delete
End Sub

To put the code into the workbook, open the workbook, press [Alt]+[F11] to
open the VB Editor. Use Insert | Module to open a new code module, then copy
and paste the code above into the module. Close the VB Editor and then
follow the instructions in the code.

HTH

 

[childofthe1980s]

Thank you, sir!!!

childofthe1980s

I'm not sure you can get there directly through keyboard commands, but this
code will do it:

Sub RemoveManyHyperlinks()
'select the column or row or group of cells
'that you want to remove hyperlinks from
'and then, with them selected, use
'Tools | Macro | Macros
'to select this macro and click the
'[Run] button to kiss them bye-bye
Selection.Hyperlinks.Delete
End Sub

To put the code into the workbook, open the workbook, press [Alt]+[F11] to
open the VB Editor. Use Insert | Module to open a new code module, then copy
and paste the code above into the module. Close the VB Editor and then
follow the instructions in the code.

HTH

Hello:

Do you know how to eliminate hyperlinks, for all cells from within a column
in Excel? I know how to do it by cell but not by column.

childofthe1980s

 

[Gord Dibben]

Copy this macro to a general module then select a column and run the macro.

Sub Delete_Hyperlinks()
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With ActiveSheet
.Hyperlinks.Delete
End With
Next Cell
End Sub

If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo.


Gord Dibben MS Excel MVP

 

[JLatham]

Gord Dibben has provided another solution, and the comments he's added about
working with VBA and workbooks are definitely worth the read.

Thank you, sir!!!

childofthe1980s

I'm not sure you can get there directly through keyboard commands, but this
code will do it:

Sub RemoveManyHyperlinks()
'select the column or row or group of cells
'that you want to remove hyperlinks from
'and then, with them selected, use
'Tools | Macro | Macros
'to select this macro and click the
'[Run] button to kiss them bye-bye
Selection.Hyperlinks.Delete
End Sub

To put the code into the workbook, open the workbook, press [Alt]+[F11] to
open the VB Editor. Use Insert | Module to open a new code module, then copy
and paste the code above into the module. Close the VB Editor and then
follow the instructions in the code.

HTH

Hello:

Do you know how to eliminate hyperlinks, for all cells from within a column
in Excel? I know how to do it by cell but not by column.

childofthe1980s