Macros in a Form

[macro troubleshooting]

I have little to no programming experience.

I have a form that my clients will fill out, but they may need the form
multiple times. There is no way to anticipate how many times they will need
this form. So, I recorded a macro that copies and pastes the form. Then, I
went and set the last field (which is a fill-in box) to run the macro upon
exit. The problem is that the form has to be protected for the form to work.
The form protection prohibits the copy and paste.

Does anyone have a better way to do this?

 

[Charles Kenyon]

Give them a template of the form and let them create a new document based on
the template when they need an additional form?

What you are talking about is what Word calls an "online form." Check this
in help. For more about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
Chapman's series of articles.

Hope this helps,

 

[macro troubleshooting]

Thank you for your response, and I am currently looking through some of the
articles on the sight you recommended. It is an excellent resource.

Well, I've thought of creating a template and having them create documents
based on it. I really do not want them to turn in 15 different documents to
me when it is complete. Let me explain myself further and perhaps someone
will come up with an even better way of doing what I'm trying to do.

I work a support job, in which people take online courses. The
administrators of the facilities sometimes choose to set up a "customized
curriculum". This means that some job codes/departments will be assigned a
set of courses.

So, my problem is they don't turn these in uniformly from facility to
facility. I have created a template so that they will all look a like when
they come back to our support desk. I need this to be as easy on my clients
as possible. So, I have created a word form (to keep them from changing the
questions) and I set up a macro in the last portion that copies this
"template section" and pastes it below it. The macro obviously does not work
because it will not add to the document while it is protected. I would just
give them a certain number of these "template sections" but they vary to
greatly. Some facilities might have 4 and some might have 24.

Any other ideas?

 

[Charles Kenyon]

Format the first paragraph of the form as page break before. This assumes
you want a separate page for the information. You could save your protected
material, including formfields, as an AutoText entry in your template. You
could have a macro that (1) unprotects the document, (2) goes to the end of
the document, (3) inserts the AutoText entry, and (4) reprotects the form
without resetting the data in formfields.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.