VBA Marco and disable Userforms on Reopen

[AmandaH]

I have a problem. I have a form that when open 2 pop-up user forms are
activated which enable to the user to enter some information that is
then used to format the form. This all works find. However when the
save and reopen the document the same 2 pop-ups are active and the user
is able to change the formatting which was already set. Any ideas on
how to disable this pop-up on reopening of the document?

 

[Suzanne S. Barnhill]

Your form should be saved as a template with an AutoNew macro instead of
AutoOpen. This will run only when a new document is created based on the
template.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[AmandaH]

Thanks for the help. However I have tried going the Template way with
this form and because it needs to be transferred around the office via
Intranet/Internet the Macros keep getting lost. The people that I am
working with are not computer literate so moving the Template into the
template folder is too advanced for them.

 

[Suzanne S. Barnhill]

Perhaps you need a protected form instead of a UserForm?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.