View Single Post
  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Robert_L_Ross Robert_L_Ross is offline
external usenet poster
 
Posts: 15
Default How To Run Macro on Open

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.