Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.
Solved
Macro for removing hyperlinks from spreadsheet
Posted on 2007-11-20
Hi Experts,
I have an Excel spreadsheet that has hyperlinks randomly scattered in different cells within the spreadsheet, is there a way of having a macro that can remove all hyperlinks in the spreadsheet. Thanks
Sam
I have an Excel spreadsheet that has hyperlinks randomly scattered in different cells within the spreadsheet, is there a way of having a macro that can remove all hyperlinks in the spreadsheet. Thanks
Sam
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
- +1
5 Comments
This will delete the hyperlink but the text will remain.
Sub test()
For Each hp In ActiveSheet.Hyperlinks
hp.Delete
Next hp
End Sub
Claus Henriksen
Sub test()
For Each hp In ActiveSheet.Hyperlinks
hp.Delete
Next hp
End Sub
Claus Henriksen
Active 4 days ago
Public Sub RemoveHyperlinks()
Dim Hyperlink As Hyperlink
Dim Count As Long
For Each Hyperlink In ActiveSheet.Hyperlinks
Hyperlink.Delete
Count = Count + 1
Next Hyperlink
MsgBox Count & " hyperlinks deleted."
End Sub
Kevin
Dim Hyperlink As Hyperlink
Dim Count As Long
For Each Hyperlink In ActiveSheet.Hyperlinks
Hyperlink.Delete
Count = Count + 1
Next Hyperlink
MsgBox Count & " hyperlinks deleted."
End Sub
Kevin
Guys, both solutions worked perfectly and have the exact timestamp when posted. So the best option is to split the points equally. Many thanks for your help.
Sam
Sam
Featured Post
![[Webinar] Lessons on Recovering from Petya](https://filedb.experts-exchange.com/files/public/2017/7/11/dcb3272a-62a8-4274-a34e-d1771610ec3b.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
: Microsoft Office Collaborate for free and online versions of Microsoft Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by Micr…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses
Course of the Month9 days, 20 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.