Deleting hyperlinks

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I set up a table of hyperlinks and then changed my mind.
So I've tried to delete, clear, clear all, fill with
other values to no avail the hyperlinks persist!
How can I get rid of, remove the links?
 
Joe...
I set up a table of hyperlinks and then changed my mind.
So I've tried to delete, clear, clear all, fill with
other values to no avail the hyperlinks persist!
How can I get rid of, remove the links?
Click to expand...

From John Walkenbach....

http://j-walk.com/ss/excel/usertips/tip031.htm
To create the macro, press Alt-F11 to activate the Visual Basic Editor,
select Insert, Module to insert a new VBA module into your project, and then
enter the following code:

Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End SubHope that helps.Regards,Kevin
 
Back
Top