Solved: Remove Hyperlinks

[GaryB]

Hi,

I have a question regarding hyperlinks on spreadsheet. Is there any way to make a global change to a make a hyperlink not be a hyperlink. All I have been able to find is standard remove hyperlink and that only works one at a time.

Thanks For any help on this.

GaryB

[vonpookie]

Yup, it's in the autocorrect options.
Tools\AutoCorrect Options\AutoFormat As You Type\uncheck the box next to "Internet and network paths with hyperlinks."

Note: That will only stop it from automatically linking addresses/e-mail addresses in the future. Any links you already have in teh sheet will still be linked.

[GaryB]

Thanks,

But I'm looking for something to remove the hyperlink for records I already have on the sheet.

Gary

[vonpookie]

For that you need a macro.

One way:
[vba]Sub RemoveHyperlinks()
Dim c As Range

Application.ScreenUpdating = False
For Each c In Selection
On Error Resume Next
c.Hyperlinks(1).Delete
On Error GoTo 0
Next c
Application.ScreenUpdating = True


End Sub
[/vba]

Select a range of cells, then run the macro to remove the links from that range.

[GaryB]

Yup, it's in the autocorrect options.
Tools\AutoCorrect Options\AutoFormat As You Type\uncheck the box next to "Internet and network paths with hyperlinks."

Note: That will only stop it from automatically linking addresses/e-mail addresses in the future. Any links you already have in teh sheet will still be linked.

It turns out I do need what you suggested also. But when I don't show an autocorrect options. I am using office 2000. I show autocorrect but non of the sub-menus show me what you suggested.

Gary

[GaryB]

Thanks Vonpookie,

The code worked like a charm. I appreciate the help.

Gary

[johnske]

No need to loop, it's slow, just use
[VBA]
Selection.Hyperlinks.Delete
[/VBA]Or, for the whole sheet
[VBA]
Cells.Hyperlinks.Delete
[/VBA]

[vonpookie]

It turns out I do need what you suggested also. But when I don't show an autocorrect options. I am using office 2000. I show autocorrect but non of the sub-menus show me what you suggested.

Gary

I don't have 2000 available to double-check, but I believe it's the same. Make sure you switch to the correct tab labeled "Autoformat as you type." The option for hyperlinks is there.