VBA: Locating Links in Edit Links Window

gquest

Board Regular
Joined
Feb 20, 2007
Messages
167
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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,448
Messages
5,837,306
Members
430,494
Latest member
abhi_is_yours

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top