Alternative to macros for creating menu-driven functions?

W

Widmer

I've developed some nice little macros in a letter template which add/remove
our company logo, add/remove footer text, shift the recipient's address into
the proper position when creating a letter which will be sent in a
window-envelope, etc. These functions are called from custom menus in Word
which call the respective macros stored in a module within the
template/document.

Two problems with our "Macro" solution:

1.) Letters created with this template are sometimes e-mailed externally. We
don't want recipients to have any of the programmed functionality, just the
text. Basically, our employees need the programmed functionality as long as
the documents are in-house. External recipients do not.

2.) Macros are being detected internal and external mail servers as "Macro
viruses".

I'd rather not have the authors remember to delete/remove macros before
e-mailing Word files.

I've seen some programs (like PDFMaker) in Word's tool bar, and I noticed
that it is using some of its own macros, but the macros are stored in each
PC's local "Microsoft Office/Office/startup" folder, and not stored with the
document itself. After briefly experimenting with the startup folder, I
couldn't duplicate this "local only" functionality. Is there some other
technology required such as COM or ActiveX? Or, does anyone recommend using
Visual Studio Tools for Office instead of Word's VBA environment? Is there
an advantage?
 
G

Graham Mayor

Don't save the macros in the document. Save them in the document template.
If they are not in the document, they will not be mailed with it.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
W

Widmer

Put a password on the protection so that it cannot be unprotected
accidentally. There is nothing to stop the user inserting the form into a
new document to remove the protection, but this then becomes more than an
'accident'.

Thank you very much for your advice.
 
G

Graham Mayor

Widmer said:
Thank you very much for your advice.

You are welcome :)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top