>I have a document protected for forms which I will be emailing out. I need
> the users to complete one of the fields before closing the document.
[quoted text clipped - 46 lines]
> Thanks for your help.
> Kristi
Thanks, Shauna! I think it's working now.
Kristi
Shauna (or anyone else),
I'm having another problem with this AutoOpen macro, etc. A few things have
changed since I posted the original question, but I thought I should still
keep the question with this thread instead of creating a new one.
I no longer need the DocumentBeforeClose event. So I am really only trying
to make something happen when the document is opened. The document is not
based on a template, it's just a regular document that will be distributed
via email.
The document is protected for Forms. There is a table in the document and
some rows of the table need to be hidden until the user clicks Yes/No on a
corresponding question. I created bookmarks for the hidden rows, hid them
using Font-Hidden, and placed Exit macros on the fields that need to trigger
the rows to appear.
I am testing the doc out with one user and the issue he is having is
inconsistency. When I first email him the document, things work fine. The
hidden fields are hidden as they should be. However, if he saves the
document, all of the hidden fields suddenly appear. Also, when he closes the
document and re-opens it, the hidden fields are all unhidden. So it doesn't
seem as if the macro is ensuring the fields are open EVERY time the document
is opened. Also, it's strange that they appear when the doc is saved, as
stated above.
Any help?
Thanks. Kristi
Doug Robbins - Word MVP - 29 Oct 2007 07:33 GMT
You are going to run into strife emailing a document that contains macros.
If the recipient has their macro security level set to high, the macro will
be stripped from the document when they open it, without any notification.
If it is set to medium, they will receive a warning message that the
document contains macros and they will be given the opportunity to accept
the document with the macros or to disable them.

Signature
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
> Shauna (or anyone else),
>
[quoted text clipped - 31 lines]
> Any help?
> Thanks. Kristi
Kristi - 29 Oct 2007 15:11 GMT
Thanks, but that's not a problem. We are putting a note to users regarding
setting their security level in the email. So we're not concerned about
that. The user who is testing this doc for me (see other post with problems)
has the macros enabled.
> You are going to run into strife emailing a document that contains macros.
> If the recipient has their macro security level set to high, the macro will
[quoted text clipped - 38 lines]
> > Any help?
> > Thanks. Kristi