I am working on a macro that allows me to copy a Word table cell’s shading to another cell, cell range, or table, whether in the same source table or another one. I want to be able to copy that shading to a table in another Word document, but each time I access another document, the userform disappears, to reappear only when I return to the original document. I have tried this with putting the macron into a global template to see if it was tied to the original, but the same thing happened. My understanding is that a userform can operate on any open document but I don’t understand how to make that happen. Can someone help show me how to do this?



I’ve attached the userform and code.

Attached Files

Copy Table Shading Test (Mar 19 2018).doc (457.0 KB, 8 views)