Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default eliminating hyperlinks from a complete column in Excel

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default eliminating hyperlinks from a complete column in Excel

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" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default eliminating hyperlinks from a complete column in Excel

Thank you, sir!!!

childofthe1980s

"JLatham" wrote:

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" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default eliminating hyperlinks from a complete column in Excel

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 InsertModule. 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 ToolMacroMacros.

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


Gord Dibben MS Excel MVP

On Mon, 14 Jul 2008 17:16:00 -0700, childofthe1980s
wrote:

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


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default eliminating hyperlinks from a complete column in Excel

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

"childofthe1980s" wrote:

Thank you, sir!!!

childofthe1980s

"JLatham" wrote:

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" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If Sheet1 column is marked complete, display entire row on Sheet2? CDZ Excel Worksheet Functions 1 October 12th 07 08:19 PM
How do I show complete answer column Susu Excel Discussion (Misc queries) 0 August 8th 06 04:50 PM
Eliminating rows in Excel worksheet 340mango Excel Worksheet Functions 1 May 24th 06 07:49 PM
DELETION OF TRIANGLES FROM COMPLETE COLUMN MEANLEANDEANE Excel Discussion (Misc queries) 3 December 20th 05 03:47 PM
HOW DO I REMOVE MARKERS IN A COMPLETE COLUMN? MEANLEANDEANE Excel Worksheet Functions 2 September 30th 05 07:52 PM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"