Coding Document Macro buttons

[MaxArk]

I have an Excel based coded application which integrates an Excel
database with a Word mail merge. The application is being developed with
users with limited computer experience and have a visual impairment. I
am trying to reduce the user's dependancy on existing Office toolbars
and taskbars, by replacing common options with buttons on the working
documents. Highly visible, and goof proof.

Here is my most recent challenge:

1. I wish to add three buttons to the documents produced by the mail
merge ... {PRINT}{SAVE}{RETURN TO EXCEL} (Excel is the launch pad of the
application). I assume I can use coded command buttons placed in the
main mail merge document to do this. But will they copy themselves to
the resulting merged document? Is this the most effective way of user
input?

2. Although these buttons will (hopefully) be functional on each newly
prepared document, I do not wish them to be printed with the document.
Can they be easily elimnated from printing?

3. How do I code leaving Word and returning to Excel, additionally,
hiding the document they had exited from?

Jenn

 

[Doug Robbins - Word MVP]

See the article "Using MacroButton fields” at:

http://www.word.mvps.org/FAQs/TblsFldsFms/UsingMacroButton.htm


--
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

 

[MaxArk]

See the article "Using MacroButton fields” at:

Hope this helps.

Hello Doug,

I have tried to integrate the suggestion provided (through you) at
http://www.word.mvps.org/FAQs/MacrosVBA/AssignMacroToButton.htm.

I am having difficulty. The feature provides macro execution with
double click of the mouse. The only place in my document I can get awa
with putting these "buttons" is in my header or footer. However, when
double click on the macro button, the header/footer editting pops up. A
I not able to use macrobuttons in header or footer?

And also ... will these buttons print with the document? No problem i
they don't, but if they do .. how can I prevent that?

Jen