Forms

[caring4211]

I'm still haven't been able to solve my problem with my form. The form was
created using the form toolbar. It has many yes or no checkboxes. If a
person marks the no checkbox, there is no need for them to go through the
rest of the question but should be able to jump down to the next question. I
wrote macros for each "no" checkbox that if it were marked, then to skip to
the next question. This works perfect on my machine but when I e-mail this
form to another person, only the first macro works. I did each macro as an
individual "sub". Should these instead be a function? As this form will be
e-mailed out to participants, they can't go in and tell each macro to run.
How do I get each macro to be "active" each time this form is opened? What
am I missing here?

Help!!!

 

[Charles Kenyon]

Chances are good that you stored the macros in your normal.dot template
rather than in the form.

With the form open on your machine, press Alt-F11 to open up the visual
basic editor. Find your macros. They are probably in normal.dot in a module
called "New Macros." If they are there, cut them and paste them into your
form, probably in the module called "New Macros."

Save the changes to normal.dot and to your form. Check to see if the macros
now operate the way you expect in your form.

What you are talking about is what Word calls an "online form." 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. You may also want to look at
http://www.word.mvps.org/FAQs/TblsFldsFms/LinesInForms.htm.

Hope this helps,