Broken Hyperlinks (lots in one sheet)

**NeedsExcelHelp** · 11-01-2011, 11:28 AM

snb. Thank you for the help. I did create it as a macro within the spreadsheet I am working, but it still seems to be unresponsive. Any ideas what I might be doing wrong?

**snb** · 11-01-2011, 12:24 PM

I hope you put it into the right sheet module.
Well, you have to run the code (alt-F8)

After that the only thing that is noticeble in the sheet is that certain links lack the understrike and have another colour.

You can post a sample workbook (containing 1 sheet and only a few rows containing hyperlinks and the macro).

**NeedsExcelHelp** · 11-01-2011, 02:22 PM

I was definitely running the code, and as I am pretty new to Macros/VBA I suspect I am simply inserting it wrong. I have attached a sheet with the Macro as you requested and deleted remaining sheets.