MacroButton Field - Run automatically

[Jules]

Is it possible to have a macrobutton field run the macro automatically when
you update fields instead of having to double click on it?
The reason I ask is that we have documents which insert fields from a
database and then need a macro to run. I cannot set the macro up as an
AutoOpen as then it runs as soon as you open the document (before it updates
the other fields) and the wrong information is inserted.
Any help would be greatly appreciated.

 

[Doug Robbins - Word MVP]

Why don't you have the code that is inserting the information from the
database call the macro that you were thinking of having run via the
macrobutton field?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Jules]

Thanks for answering so quickly. Unfortunately I cannot get into the code
that inserts the info from the database as it comes from a custom application
which we purchased and we cannot access their templates. If there is no way
to run the macrobutton field automatically I can tell the users that it is
there and that they will have to run it whenever they create the document and
just hope they remember.