Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If Sheet1 column is marked complete, display entire row on Sheet2? | Excel Worksheet Functions | |||
How do I show complete answer column | Excel Discussion (Misc queries) | |||
Eliminating rows in Excel worksheet | Excel Worksheet Functions | |||
DELETION OF TRIANGLES FROM COMPLETE COLUMN | Excel Discussion (Misc queries) | |||
HOW DO I REMOVE MARKERS IN A COMPLETE COLUMN? | Excel Worksheet Functions |