View Single Post
 
Old 10-22-2024, 03:07 AM
Shelley Lou Shelley Lou is offline Windows 10 Office 2016
Expert
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA Unlink Cross Reference Fields for Specific Text

I am currently updating the styles of a lot of 200 page documents and need to unlink any cross references within the document that begin with specific text 'Part' or 'Schedule' but leave all other cross references linked. How would I go about creating a macro to only unlink if the cross ref field begins with 'Part' or 'Schedule'. Thanks.


Image of cross refs Part and Schedule before unlinked
Unlink Specific Cross Refs.JPG

Image of cross refs Part and Schedule after unlinked
Image of Unlinked Cross Refs.JPG

Unlink cross ref for Part and Schedule.DOCX
Reply With Quote