Excel VBA - Checking for inactive hyperlinks

M

mrice

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
 
Top