macropod,

Many thanks for the reply as this problem has me stumped for the past couple days. However, I am not sure I totally understand what you are saying. I did not save the document as a template I saved the document as a .docm. What exactly do you mean when you say "macro isn't in the document but in its template"?

I have no prior experience do writing macros in VB script so my knowledge is very limited. I am pretty certain the document security on the other machine is set to "Disable all macros with notification", however I do not get any notification. If I copy and paste the code directly into the document and save it locally on the new machine then close/reopen it works. Seems to me this should be a simple problem but I have not yet resolved the problem.

Thanks again macropod for your help,

Joe