Getting Rid of Hyperlinks and Restoring them to a double
 

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

Getting Rid of Hyperlinks and Restoring them to a double
 

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

--
Rick (MVP - Excel)



"Philosophaie" wrote in message
...
How do you get rid of Hyperlinks and restoring them to a double in VBA
code?

Getting Rid of Hyperlinks and Restoring them to a double
 

I found this and it works:

ActiveSheets.Cells.Hyperlinks.Delete


"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)



"Philosophaie" wrote in message
...
How do you get rid of Hyperlinks and restoring them to a double in VBA
code?

.