Thread: [Solved] Is there a way to stop macro modifications from undoing when Updating Word Linked Tables?
View Single Post
 
Old 06-25-2021, 01:48 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Anything you do in Word to refresh a field - which includes the LINK fields that are used when Word sources data from Excel - will erase any formatting you have applied to the field's result. The behaviour is by design and cannot be overridden.

Contrary to what you say, it doesn't matter whether the change is made via a macro or manually. Since your macro doesn't do anything to refresh the link, I cannot see how that would affect any other formatting you have applied to the table. That said, I cannot see the point of setting the row heights to 0.1mm...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote