VBA: Locating Links in Edit Links Window

[gquest]

Has anyone come across or created a macro that shows the locations of a given link in a workbook (sheet & cell)?

It would be really sweet if Excel had that option in the Edit Links Window to perform this task.

Normally, open the Edit Links window, write down some of the location, and do a find for that location.

As I'm sure many of you know, if you're trying to locate a lot of links this can be a very tedious process. I was thinking about writing a macro that would pull up a user form with a list of all the links in the workbook, allow you to select a link, and the run some code that would create a sheet with a list of all the locations in the workbook. However, if this already exsist out there then that would be a huge time save.

Has anyone every seen anything like this out there?

Thanks,

George

 

[Andrew Poulsom]

This may help you:

http://www.mrexcel.com/archive/Links/17278.html

 

[gquest]

This may help you:

http://www.mrexcel.com/archive/Links/17278.html

Thanks, Andrew! This is great, not quite what I need, but almost there. Now I just need to somehow adjust the 'Link List' to include the locations of each link throughout the worksheet in the columns to the right of the link.