Group:  Microsoft Word ยป microsoft.public.word.vba.beginners
Thread: Get rid of user form in new document

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Get rid of user form in new document
Diana Morrison 26.09.2006 17:45:02
I have a Word .dot Template that collects header / footer info and puts it
into a document using a UserForm. Then each GM fills out the report. They
click a macro button at the end which changes the font, password protects and
saves the document to a certain file. All is well, so far (thanks Jay
Freedman!). Problem is, when the President opens each newly created .doc
document to review the reports, the UserForm appears. How do I get rid of it?
Thanks,
Diana Morrison
Re: Get rid of user form in new document
"Jean-Guy Marcil" <NoSpam[ at ]LeaveMeAlone> 27.09.2006 00:13:55
Diana Morrison was telling us:
Diana Morrison nous racontait que :

[Quoted Text]
> I have a Word .dot Template that collects header / footer info and
> puts it into a document using a UserForm. Then each GM fills out the
> report. They click a macro button at the end which changes the font,
> password protects and saves the document to a certain file. All is
> well, so far (thanks Jay Freedman!). Problem is, when the President
> opens each newly created .doc document to review the reports, the
> UserForm appears. How do I get rid of it? Thanks,
> Diana Morrison

You probably have code in a Document_Open sub (or AutoOpen) while it seems
you only need the code in the Document_New sub (Or AutoNew).
Could that be the case?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE[ at ]CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net