I am trying to put together some VB code that takes a sheet of hyperlinks and:

follows them allowing the user to check that it looks ok
if an error is detected to trap it and report on it as a broken link
if a logon dialog box is presented because it is a secure section, to simply identify that it has happened and return a value back to the code.


I have got it going through the code and following each hyperlink. I have "resume next" so I can trap the errors.

What I can't get is a way to close the IE windows on returning to the workbook, or a way of inhibiting the "logon required" window and simply report back. If the user presses the "cancel" button for the logon, it gets treated the same as a broken link.


Any ideas?