Hi Skarab,

As coded, the macro should go in the Document's 'ThisDocument' module, not in an ordinary code module. It will then run automatically when the document is opened.

For use in a template, change the macro's name to 'Document_New' and put it in the Template's 'ThisDocument' module. That way, any new document created from the template will get the prompt.

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