Find Links
 

Hello. Anyone have any code that will scan every sheet within a workbook
and highlight each cell that has a link to an external file (ie .xls)?
Thanks!

Find Links
 

Go to this link. Neat little download to find and remove links.

http://acctadv.com/exceldownloads.php

Bill


"Steph" wrote in message
...
Hello. Anyone have any code that will scan every sheet within a workbook
and highlight each cell that has a link to an external file (ie .xls)?
Thanks!

Find Links
 

Hi Bill. Thanks for the response. I already have that utility...and it is
great! But I don't so much want to find the link and list them on another
sheet. I really need to identify all of them with a highlight. I have a
huge workbook with literally thousands of links. It would be great to
visually see exactly which cells contain external links rather than viewing
a list from the utility on a different sheet.

"Bill" wrote in message
ink.net...
Go to this link. Neat little download to find and remove links.

http://acctadv.com/exceldownloads.php

Bill


"Steph" wrote in message
...
Hello. Anyone have any code that will scan every sheet within a
workbook
and highlight each cell that has a link to an external file (ie .xls)?
Thanks!

Find Links
 

There is a word file in the second link on that page that explains how the
file works. It has some code. You might be able to use it build your own.

Bill


"Steph" wrote in message
...
Hi Bill. Thanks for the response. I already have that utility...and it
is
great! But I don't so much want to find the link and list them on another
sheet. I really need to identify all of them with a highlight. I have a
huge workbook with literally thousands of links. It would be great to
visually see exactly which cells contain external links rather than
viewing
a list from the utility on a different sheet.

"Bill" wrote in message
ink.net...
Go to this link. Neat little download to find and remove links.

http://acctadv.com/exceldownloads.php

Bill


"Steph" wrote in message
...
Hello. Anyone have any code that will scan every sheet within a
workbook
and highlight each cell that has a link to an external file (ie .xls)?
Thanks!