Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlinks to Files, Make Them Go Away
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. |
#2
|
|||
|
|||
I solved this problem. Somehow the hyperlinks were in every cell of rows 1
to 243 and then from row 65,000 to the end. Once I deleted the bottom-most rows the vba script was able to delete the remaining hyperlinks. |
#3
|
|||
|
|||
Hi Joe,
You realize that the macro works on a selection of cells. http://www.mvps.org/dmcritchie/excel/buildtoc.htm I can't duplicate what you say you are getting. There is one foible with generating a bunch of hyperlinks with the fill handle. Several of them are the same hyperlink or act like it so if you destroy some of them with the macro -- you actually destroy more than a selection of only some of them. But that sounds rather opposite of the problem you are experiencing. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Joe Reggae" wrote in message ... 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. |
#4
|
|||
|
|||
Hi Joe,
Sorry missed your own reply. Were those other links actually all for the same link address. Not that I have an answer but it looks like it could be what I was indicating. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Joe Reggae" wrote in message ... I solved this problem. Somehow the hyperlinks were in every cell of rows 1 to 243 and then from row 65,000 to the end. Once I deleted the bottom-most rows the vba script was able to delete the remaining hyperlinks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |