Macro for changing hyperlink fonts?

Question

So I have been recording macros all morning with no success. Here's my situation:

I have a LOT of documents to go through and update. In each of these documents are many hyperlinks that for some reason, match the rest of the text (black, Calibri, size 12) rather than showing up in traditional hyperlink blue. I want them to be blue so I can find and fix the them easily (most of them are broken), but if I select them using Alt-F9 and then change the Style to Hyperlink, the font changes to Times New Roman. Even when I update the style and select the option to apply it to new documents from now on, the style still makes my hyperlinks Times New Roman the next time I use it.

SO. I want a macro that selects all hyperlinks, underlines them, changes the font to Calibri and changes the color to blue (red = 0, green = 0, blue = 255). It seems like it shouldn't be this complicated! (But I'm not very experienced in VBA.)

Any help would be much appreciated.

Answer 1

You don't have to (re-)apply styles to your hyperlinks. Modifying the built-in hyperlink styles to suit the needs of your document will suffice. Specifically, you will have to modify both the Hyperlink and the FollowedHyperlink styles.