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]