by Allen Wyatt
(last updated November 5, 2014)
Do you create worksheets by pasting information that was copied from the Internet? This is not unusual for some people, as there is quite a bit of public-domain information that can be copied from the Internet. When you paste your information into a worksheet, you may notice that there are quite a few hyperlinks. What if you want to get rid of those hyperlinks? Similarly, you might inherit a worksheet from someone, and it contains a lot of hyperlinks you want deleted.
The easiest approach is to run a macro that deletes all the hyperlinks. The following macro quickly removes all hyperlinks in a worksheet, without affecting anything else it may contain:
Sub KillLinks() Do Until ActiveSheet.Hyperlinks.Count = 0 ActiveSheet.Hyperlinks(1).Delete Loop End Sub
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3249) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
If you want people to know something about a hyperlink you added to your worksheet, one way to help them is to use ...Discover More
Does it bother you when you enter a URL and it becomes "active" as soon as you press Enter? Here's how you can turn off this ...Discover More
Inserting a hyperlink into a workbook that is shared with others is not possible in Excel. Here's what you can do about it.Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."