Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / July 2003

Tip: Looking for answers? Try searching our database.

Remove UserForm

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
William Dihle - 30 Jul 2003 11:48 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.