removing hyperlinks
 

Try selecting the cells from which the hyperlinks are to be removed and run
this macro:

Sub hypergone()
Selection.Hyperlinks.Delete
End Sub
--
Gary's Student


"Laura" wrote:

How do you remove hyperlinks in an Excel file? I tried getting answers from
Help, but the instructions didn't help me. In one of the answers it said
to right click on the hyperlink that I wanted to remove and select Remove
Hyperlink, which I tried but there was no such option on my menu.

Another answer involved typing 1 in a blank cell, then copying it, and then
I don't know what the heck it was talking about!! It was way too complicated
for me!

Isn't there a simple way to remove hyperlinks?

Thanks.