Disable hyperlinks that already exist
 

Anyway to disable hyperlinks that already exist in an excel document? I know
of the disable in autocorrect but this is when the document comes from
someone else who has made the hyperlinks active...

Disable hyperlinks that already exist
 

Have you tried right clicking the link and selecting remove hyperlink?

"Ken" wrote:

Anyway to disable hyperlinks that already exist in an excel document? I know
of the disable in autocorrect but this is when the document comes from
someone else who has made the hyperlinks active...

Disable hyperlinks that already exist
 

Are the hyperlinks created using the =HYPERLINK function?

If so, the following wil not work and you will have to remove them
individually.

Otherwise, run this macro.

Sub DelAllHyperlinks()
ActiveSheet.HyperLinks.Delete
End Sub


Gord Dibben MS Excel MVP

On Wed, 17 Sep 2008 13:11:00 -0700, Ken
wrote:

Anyway to disable hyperlinks that already exist in an excel document? I know
of the disable in autocorrect but this is when the document comes from
someone else who has made the hyperlinks active...