A VBA macro can't get the correct color of a hyperlink in MS Word

rollis13 · #1 06-09-2022, 03:53 AM

In your example char.Font.Color of the first character of the hyperlink will return 9999999 and not wdColorBlue. Add the test on that value to this line of code:

Code:

If char.Font.Color <> wdColorAutomatic And char.Font.Color <> wdColorBlack _
   And char.Font.Color <> wdColorBlue Then

Jimmy · #2 06-09-2022, 07:07 AM

rollis13, thanks for your reply.

I'd like to know why char.Font.Color returns 9999999 other than wdColorBlue.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to change an RGB table cell shading color to another RGB color	David Matthews	Word VBA	4	05-29-2018 02:45 PM
Correct Bookmark Hyperlink	Phil H	Word	2	02-10-2016 12:55 PM
Word 2003 - Macro to color a row in table?	cyberpaper	Word	2	01-03-2013 02:07 PM
Word macro to email hyperlink	pooley343	Word VBA	0	07-20-2011 01:48 AM
Change Follwed Hyperlink color in Word 2010	Henry	Word	1	07-05-2011 04:29 PM