Firstly, you can import styles from attached template more simply


Secondly, where is the code you are running residing? If it is in the attached template and you then change the attached template, how does it stay available? Perhaps place the code in Normal, an addin, or document if it includes changing the attached template.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thanks for the tip on updating the styles with the single command! My journey into macros started with recording them (like a lot of others I'm sure) and that's what it records when you do the manual procedure and I never looked into anything more efficient.

I have a fairly complicated setup which tries to deal with all sorts of eventualities and they're all to do with SharePoint and how it tries its best to mess with templates and styles. The master "refresh" macro lives in a separate template that people have on their own computers (in the Word startup folder) and is tasked with first linking the correct template.

The document templates all have their own macro which does the actual refreshing, as there's no one size fits all process for the refreshing (sometimes the document has custom numbering which we don't want to reset with a refresh, or sometimes some substitution needs to be done with SharePoint paths as the synced folder name and the URL don't match if someone renames the site). That's called by the master macro.

Your simple solution will work most of the time, however there's a few instances where the document is linked to a template with a valid update macro, but I want to change it to a different one. I think this would have to involve using my method, which is where the issue becomes relevant again.