Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ascertaining whether external data sources or hyperlinks exist | Excel Discussion (Misc queries) | |||
E-mail hyperlinks-need to disable these | Excel Discussion (Misc queries) | |||
E-mail hyperlinks-need to disable these | Excel Discussion (Misc queries) | |||
Disable hyperlinks on entry | Excel Discussion (Misc queries) | |||
How do I disable hyperlinks in Excel? | Excel Discussion (Misc queries) |