Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
AmandaH AmandaH is offline
external usenet poster
 
Posts: 54
Default VBA Marco and disable Userforms on Reopen

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?

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default VBA Marco and disable Userforms on Reopen

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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"AmandaH" wrote in message
ps.com...
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?


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
AmandaH AmandaH is offline
external usenet poster
 
Posts: 54
Default VBA Marco and disable Userforms on Reopen

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 wrote:
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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"AmandaH" wrote in message
ps.com...
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?


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default VBA Marco and disable Userforms on Reopen

Perhaps you need a protected form instead of a UserForm?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"AmandaH" wrote in message
oups.com...
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 wrote:
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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"AmandaH" wrote in message
ps.com...
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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable Marco dialog box in Word Sherry Microsoft Word Help 1 September 30th 05 05:39 PM


All times are GMT +1. The time now is 11:50 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"