I am pretty good with excel, but know nothing about VBA or using macros. I have seen similar posts, but because I know so little, I don't know how to make them work for me.
I have several files where different pieces of data in the file are hyperlinked to a network folder (such as a customer's name in a list hyperlinked to the customer's folder) or a file on the network (such as a date hyperlinked to a pdf file of a document with that expiration date). I want to be able to highlight in purple (just to be sure I'm using a different color than anything else in the sheet) any links that are dead or broken on all sheets of the workbook.
Most of the time the issue is that the file has been moved or renamed, so when the link is clicked I get the error "Cannot open specified file.". I just want to be able to identify those hyperlinks without having to actually click every one. Then I can correct them as needed.
I'm hoping for something that doesn't actually open every file, as that would be a show stopper because there are so many links. And, I'm hoping for something that would work in any excel file, because I don't know enough to change the VBA every time.
Bookmarks