View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mrice[_3_] mrice[_3_] is offline
external usenet poster
 
Posts: 1
Default Excel VBA - Checking for inactive hyperlinks

I have a spreadsheet which contains several hundred hyperlinks. I'
looking for a programatic way of detecting which ones are inactive.
expect that there are only a few but I don't know which.

I want to avoid repetitively using the Hyperlink .follow method as i
appears to open a new instance of Internet Explorer for each one.

Any advice gratefully received.

Marti

--
Message posted from http://www.ExcelForum.com