Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 07-31-2023, 03:36 PM
Marrick13 Marrick13 is offline Change color of hyperlinks in multiple documents Windows XP Change color of hyperlinks in multiple documents Office 2010 32bit
Competent Performer
Change color of hyperlinks in multiple documents
 
Join Date: Jun 2006
Posts: 102
Marrick13 will become famous soon enough
Default Change color of hyperlinks in multiple documents

I added that with options code and I didn't see any difference. The hyperlink style was not applied to the links in the test documents. I have attached 2 of those 3 test files along with the latest macro ("Update Document Link Color").

There are other issues with this macro:

1. Sometimes it opens only the files in the selected folder, but mostly it opens those AND other files, possible some on One Drive. But since I select one folder (on my regular desktop), I expect it to look only there.

2. Various attempts to set the font color in the hyperlink style of each document opened by the macro have failed.

3. The macro does not apply the hyperlink style to the links in the document opened by the macro.

I have had success ON OCCASION with numbers 1-3 above, but each time I ran the macro again, it did not do what it is supposed to do. I don't know what else to do with this thing. I've spent hours and hours trying different things (and I am not a VBA developer) and coming up empty. Perhaps you can look at the code and give me some advice. It seems that, since Word is driven by style, it should be fairly easy to create a macro that opens Word documents, sets their hyperlink styles (followed hyperlinks as well), and applies those styles to the links in those documents, saves them and closes them.
Attached Files
File Type: docm Update Document Link Color.docm (25.5 KB, 4 views)
File Type: docx Test1.docx (28.6 KB, 6 views)
File Type: docx Test2.docx (25.9 KB, 8 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change color of hyperlinks in multiple documents VBA to change multiple change drop down font color and make bold bwhitlock Word VBA 1 08-08-2022 12:18 AM
Change color of hyperlinks in multiple documents How to change multiple hyperlinks in word 2019 Zakko Word 5 04-08-2019 08:04 PM
Change color of hyperlinks in multiple documents Removing Hyperlinks in Multiple Documents at Once Jude24Joy Word VBA 10 06-13-2017 05:38 AM
Change the color of multiple borders Jim Robison Excel 2 09-06-2016 11:08 AM
Change color of hyperlinks in multiple documents Change Multiple Documents from US to UK language swifty2010 Word 1 03-08-2011 02:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft