Getting Rid of Hyperlinks and Restoring them to a double

[Philosophaie]

How do you get rid of Hyperlinks and restoring them to a double in VBA code?

 

[Rick Rothstein]

Try selecting them and then click Edit/Clear/Formats on the menu bar.

 

[Philosophaie]

I found this and it works:

ActiveSheets.Cells.Hyperlinks.Delete