Can I get my macro to run upon opening my Word document? I have ASK fields
that the users needs to populate, but I want to come up automatically so that
they will not have to remember the macro command.

Call the macro AutoNew (to run once, when the document is first created) or
AutoOpen (to run every time the document is opened).



"G Lee" G wrote in message
...
Can I get my macro to run upon opening my Word document? I have ASK
fields
that the users needs to populate, but I want to come up automatically so
that
they will not have to remember the macro command.

[Robert_L_Ross]

Jezebel,

So I have a document template with a userform. I have a sub that filters
data I'm pulling from Excel to put into a combobox on my userform.

When I open my .dot, the .doc is created and the userform displays...how do
I get a macro to run from that userform code?

For example, I have three checkboxes that filter the data returned from
Excel...I don't want to put the filter on all three checkboxes (that's three
places I have to update instead of one). How do I get my checkbox_click to
run a sub located in module1?

"Jezebel" wrote:

Call the macro AutoNew (to run once, when the document is first created) or
AutoOpen (to run every time the document is opened).



"G Lee" G wrote in message
...
Can I get my macro to run upon opening my Word document? I have ASK
fields
that the users needs to populate, but I want to come up automatically so
that
they will not have to remember the macro command.

[Graham Mayor]

Maybe you should take a look at some basic information on userforms at Word
MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm. You will find some more real world
examples on Greg Maxey's web site http://gregmaxey.mvps.org/word_tips.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Robert_L_Ross wrote:
Jezebel,

So I have a document template with a userform. I have a sub that
filters data I'm pulling from Excel to put into a combobox on my
userform.

When I open my .dot, the .doc is created and the userform
displays...how do I get a macro to run from that userform code?

For example, I have three checkboxes that filter the data returned
from Excel...I don't want to put the filter on all three checkboxes
(that's three places I have to update instead of one). How do I get
my checkbox_click to run a sub located in module1?

"Jezebel" wrote:

Call the macro AutoNew (to run once, when the document is first
created) or AutoOpen (to run every time the document is opened).



"G Lee" G wrote in message
...
Can I get my macro to run upon opening my Word document? I have
ASK fields that the users needs to populate, but I want to come up
automatically so that they will not have to remember the macro
command.

[Robert_L_Ross]

Graham,

Maybe I missed it, but I didn't see any references to calling one set of
code from a currently running code on those pages.

"Graham Mayor" wrote:

Maybe you should take a look at some basic information on userforms at Word
MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm. You will find some more real world
examples on Greg Maxey's web site http://gregmaxey.mvps.org/word_tips.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Robert_L_Ross wrote:
Jezebel,

So I have a document template with a userform. I have a sub that
filters data I'm pulling from Excel to put into a combobox on my
userform.

When I open my .dot, the .doc is created and the userform
displays...how do I get a macro to run from that userform code?

For example, I have three checkboxes that filter the data returned
from Excel...I don't want to put the filter on all three checkboxes
(that's three places I have to update instead of one). How do I get
my checkbox_click to run a sub located in module1?

"Jezebel" wrote:

Call the macro AutoNew (to run once, when the document is first
created) or AutoOpen (to run every time the document is opened).



"G Lee" G wrote in message
...
Can I get my macro to run upon opening my Word document? I have
ASK fields that the users needs to populate, but I want to come up
automatically so that they will not have to remember the macro
command.

[Graham Mayor]

The code to run a macro from another is

Application.Run MacroName:="macroname"


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Robert_L_Ross wrote:
Graham,

Maybe I missed it, but I didn't see any references to calling one set
of code from a currently running code on those pages.

"Graham Mayor" wrote:

Maybe you should take a look at some basic information on userforms
at Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm. You will find some more
real world examples on Greg Maxey's web site
http://gregmaxey.mvps.org/word_tips.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Robert_L_Ross wrote:
Jezebel,

So I have a document template with a userform. I have a sub that
filters data I'm pulling from Excel to put into a combobox on my
userform.

When I open my .dot, the .doc is created and the userform
displays...how do I get a macro to run from that userform code?

For example, I have three checkboxes that filter the data returned
from Excel...I don't want to put the filter on all three checkboxes
(that's three places I have to update instead of one). How do I get
my checkbox_click to run a sub located in module1?

"Jezebel" wrote:

Call the macro AutoNew (to run once, when the document is first
created) or AutoOpen (to run every time the document is opened).



"G Lee" G wrote in message
...
Can I get my macro to run upon opening my Word document? I have
ASK fields that the users needs to populate, but I want to come up
automatically so that they will not have to remember the macro
command.