How to make the dialog box automatically load?

[Robert]

I have a template with an attached dialog box (userform).
Whenever a new document is created based on the template,
I want the dialog box to show as well. How do I make this
happen automatically? Do I use AutoNew? Thanks.

 

[Perry]

happen automatically? Do I use AutoNew? Thanks.
You could use AutoNew

You can use:
Document_New event of thisdocument object as well.

More info
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
l/wohowautomacros.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd10/htm
l/woevtnew.asp

Krgrds,
Perry

 

[Cindy M -WordMVP-]

Hi Robert,

I have a template with an attached dialog box (userform).
Whenever a new document is created based on the template,
I want the dialog box to show as well. How do I make this
happen automatically? Do I use AutoNew?

Yes, AutoNew would be good

Or the Document_New event in the ThisDocument modula.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[dbddavid]

Robert
If you only want the dialog box to appear when a new document opens you
could use a macro, but if you name the macro AutoNew if anyone would go
to the macro area of Word they would be able to run it anytime they
wuld want. A better method would be to create a subroutine for the
document and name it Document_New. This subroutine will only open when
a new docuemnt is created based on the template.

 

[Guest]

-----Original Message-----
I have a template with an attached dialog box (userform).
Whenever a new document is created based on the template,
I want the dialog box to show as well. How do I make this
happen automatically? Do I use AutoNew? Thanks.
.

Open the template, go to VB Editor and open the code
module for ThisWorkbook. Find the Workbook_New event and
enter the following code

MyUserForm.Show

The assumption in this case is of course that MyUserForm
is the name of the form