I have a template which opens a userform (autorun code), which prompts the
user to rename the document and then immediately saves it as a .doc file in
a specified directory. Once the new document based on the template is
saved, I want the userform stripped out so that when the document is opened
again afterward, the userform does not again open. Preferably, the userform
and vba code would be stripped out, reducing the size of the document as
well as doing away with the userform popping up.
Doug Robbins - Word MVP - 30 Jul 2003 13:41 GMT
Hi WIlliam,
If the userform is called by an AutoNew macro in the template, the userform
will not appear when a document created from that template is re-opened.
If sounds like what you are doing is having the user open the template and
then save it with a different name. Your users should be selecting New from
the File menu and then select that template as the basis for the document
that they want to create. When it is done this way, there will be no
userform or code in the document itself.
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
> I have a template which opens a userform (autorun code), which prompts the
> user to rename the document and then immediately saves it as a .doc file in
[quoted text clipped - 3 lines]
> and vba code would be stripped out, reducing the size of the document as
> well as doing away with the userform popping up.