Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I'm using Excel 2002 and have a spreadsheet in which nearly every cell has somehow come to contain an unwanted hyperlink to an external file. I can remove these links one cell at a time (right-click, Remove Hyperlink), however there are too many cells affected to do this manually. I have tried using a macro ... Sub RemoveHyperlinks() Selection.Hyperlinks.Delete End Sub but this has no effect. The link text (shown in a tooltip) is ... file:///C:\Desktop Guidelines\3.00 Piping Inspection Programs\3.08 Below Grade Piping Inspection Guidelines\3.08.11 Excavated Pipe Inspection Guideline.doc Can anyone suggest a way to get rid of these links? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks to files on network drivers | New Users to Excel | |||
I have problems with hyperlinks to Adobe pdf files | Excel Discussion (Misc queries) | |||
How can I make Excel Files save as the text appers in a cell, can. | Excel Discussion (Misc queries) | |||
hyperlinks to bookmarks in pdf files | Excel Discussion (Misc queries) | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) |