[Jay Freedman]

If the macro is in a template, and the form that you're sending to others is
a document based on the template, that's the problem. When you base a
document on a template, any macros remain only in the template and are not
copied into the document. Sending the document without the template then
breaks the linkage to the macro.

The easiest solution is to send the template itself. Be sure to explain to
the recipients that if a macro warning appears on opening the template, they
should click the Enable button.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

ah wrote:
hi;

I have a form with a macro as I have 25 selection list on it. And the
selection list for all the fields are associated with the country
field that the user selects.
It is running successfully in my laptop. However, when I send it to my
client, the macro is no longer available.Can anyone guide me to on
how to make the macro runs automatically once the client open the
form?FYI, this form will be distibuted to lots of users, thus all of
them are not located within the same network. I found that the exit
macro is no longer available when I send the form to my client.

Appreciate if anyone could help urgently. Thanks a lot!