Macro Execution

[Mike Schelling]

I'm really new at this VBA stuff. Please bare with me.

I have a form template that will be used by field offices to submi
information back to their headquarters as a .doc. When headquarter
receives the .doc they will review the content and make changes whe
necessary. After headquarters reviews the content the information wil
be placed in the database.

My Testing: I haven't figured out the update process yet. So I made
'Hello World' macro to see if I could run it when I had the documen
open in Word. I can if I unprotect the document, but can't when th
document is protected.

Problem: I want to have a macro that only headquarters can execute t
do the database update. How do I make this macro available to onl
headquarters? I would rather not imbed it in the template. Can I assig
a macro as a toolbar choice?

Mik

 

[Jean-Guy Marcil]

I'm really new at this VBA stuff. Please bare with me.

I have a form template that will be used by field offices to submit
information back to their headquarters as a .doc. When headquarters
receives the .doc they will review the content and make changes when
necessary. After headquarters reviews the content the information will
be placed in the database.

My Testing: I haven't figured out the update process yet. So I made a
'Hello World' macro to see if I could run it when I had the document
open in Word. I can if I unprotect the document, but can't when the
document is protected.

Problem: I want to have a macro that only headquarters can execute to
do the database update. How do I make this macro available to only
headquarters? I would rather not imbed it in the template. Can I assign
a macro as a toolbar choice?

Right, do not embed it in the field office template.
Store it in a global template (A template that contains only macros,
toolbars and autotexts that you store in the start up folder: Tools >
Options > File Locations tab) that only headquarters will have.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Mike Schelling]

Merci..