This could be considered part 2 to my previous post which was solved quite nicely. In searching the net, it seems that it may be possible to determine which of the created hyperlinks are real (active). I just used the script and it worked well but sitting and clicking goes on and on. The first link that worked was try 406.
Is it possible to create a macro which goes through the hyperlinks and finds which, if any, are currently active?
I have a list of 676 hyperlinks on Sheet 2 as shown in the previous post.
Much appreciated.
I am attaching the file from the previous post as well as the script which was amended ( magically by Pike) to create the hyperlinks.
Thanks again, again.
Please note that the "022510" is a date.
Bookmarks