Thanks, Paul. Appreciate the response.

I work in a training environment where all of our content (storyboards, scripts, transcripts, etc.) is located in Word docs spread across several departments. A recent mandate came down that requires us to search every document for key terms. If one or more is found, the document must be flagged for review.

Documents are spread out across the organization, so searching within a folder won't do. Every doc needs to be opened and searched. Since the docs already exist, I thought a macro would be a quick solution. I can't share the code, but it seems to work fine as far as flagging and highlighting any key term it finds.

The issue I have is that my macro is local to my document. All other existing documents (built using the standard Normal.dot) are in different locations and folders and even on SharePoint sites, won't have the macro. So, if I tell 'Mary' to review the ExampleContent.doc file and search for these key terms, Mary won't find the macro in that doc.

My question is, what is the process to get access to my macro from within the other documents? I can't simply email the macro, and I don't want people going into VBA and pasting code. That would be a nightmare.

Do I have each reviewer update their Normal.dot templates with my macro? Or is it the Normal.dotm template? Or am I out of luck?