eliminating hyperlinks from a complete column in Excel

C

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
 
J

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
 
C

childofthe1980s

Thank you, sir!!!

childofthe1980s

JLatham said:
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 said:
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
Click to expand...
Click to expand...
 
G

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
 
J

JLatham

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

childofthe1980s said:
Thank you, sir!!!

childofthe1980s

JLatham said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top