|
|
|
|
|
|
Excel
|
Remove or Delete Underlying Hyperlinks in a Predefined Range
|
|
Ease of Use
|
Easy
|
Version tested with
|
2000
|
Submitted by:
|
Anne Troy
|
Description:
|
Removes the hyperlinks in a specified range, leaving the visible text behind.
|
Discussion:
|
You copied a bunch of stuff from the web, and it's got a bunch of hyperlinks under it that you don't want...you just want the text. Use this macro to keep the text and trash the hyperlinks.
|
Code:
|
instructions for use
|
Sub RemoveHyperLinks()
Range("A1:A10").Hyperlinks.Delete
End Sub
|
How to use:
|
- Copy the code above.
- Open your workbook.
- Hit Alt+F11 to open the Visual Basic Editor (VBE).
- Choose Insert-Module from the menu.
- Paste the code into the window at right.
- Change the range A1:A10 to desired range of cells (A:A would do the entire Column A).
- Close the VBE.
|
Test the code:
|
- Go to Tools-Macro-Macros and double-click RemoveHyperlinks.
|
Sample File:
|
deletehyperlinks.zip 7.1KB
|
Approved by mdmackillop
|
This entry has been viewed 106 times.
|
|