Hello,



I am very new to macros and word documents. However, recently I have a new project which requires me to build a macro-enabled word document .dotm file. The file has an embeded vb script which does work properly. So made saved it and made a copy, put it on a usb stick, and moved it to another machine. However, on the new machine the macro is totally gone and so the script never fires.

Does anyone have any idea on what the problem could be. The machine seems to have identical security settings so why does it work on one machine and not the other?

Any help or advise would be greatly appreciated.

Thanks in advance,
Joe

Your description suggests the macro isn't in the document but in its template; even a docx file would work the same way in such circumstances. Either that or the destination PC has its macro security set to disable all macros without notification - see under File|Options|Trust Center>Trust Center Settings>Macro Settings.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

Please pay attention to what I posted. I did not suggest you saved the document as a template; I suggested the macro might be in the document's template and not in the document itself. There's a world of difference between a document and a template and you should take time to learn how documents relate to templates.

Every document is based on a template. Macros in a template are available to any document based on that template regardless of the save format - provided they can access the template. Your statement
confirms that you had added the code to the document's template and not to the document itself.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]