Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2007

Tip: Looking for answers? Try searching our database.

Drop-down box results create multiple tables?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steven - 15 Aug 2007 16:42 GMT
Would anyone know of any macro that is tied into the output given by a
drop-down box ( for instance a Number of Parcels drop down box ), which will
in-turn create/remove additional data within the document without actually
Un-Protecting the document?

For instance..

Number of Applicants: [Drop down box containing numbers 1-10]

Now, if you pick 3, it creates 3 tables of information/userforms, each table
simply being a copy of the next...

Applicant 1:
Name: [user input form]
Address: [user input form]
Phone#: [user input form]

Applicant 2:
Name: [user input form]
Address: [user input form]
Phone#: [user input form]

Applicant 3:
Name: [user input form]
Address: [user input form]
Phone#: [user input form]
Jean-Guy Marcil - 16 Aug 2007 03:31 GMT
Steven was telling us:
Steven nous racontait que :

> Would anyone know of any macro that is tied into the output given by a
> drop-down box ( for instance a Number of Parcels drop down box ),
[quoted text clipped - 22 lines]
> Address: [user input form]
> Phone#: [user input form]

If the document is protected, you will have to unprotect it to modify its
content.

Why don't you want to unprotect it?

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Steven - 17 Aug 2007 14:22 GMT
I'd like to keep the document protected in an effort to keep the user
(employee) from taking out too much information from the report.  Believe it
or not, people like to take the easiest way out of work, so if there is
information that is not easily found by research, they'll just delete the
whole section from the report! We have contracts with clients that require
specific research, therefore our reports need to reflect that with
consistency and accuracy.

> Steven was telling us:
> Steven nous racontait que :
[quoted text clipped - 30 lines]
>
> Why don't you want to unprotect it?
Brian - 17 Aug 2007 14:46 GMT
A slight increase in staff turnover may have the desired effect.
Signature

Brian McCaffery

> I'd like to keep the document protected in an effort to keep the user
> (employee) from taking out too much information from the report.  Believe it
[quoted text clipped - 38 lines]
> >
> > Why don't you want to unprotect it?
Jean-Guy Marcil - 21 Aug 2007 03:15 GMT
Brian was telling us:
Brian nous racontait que :

> A slight increase in staff turnover may have the desired effect.

LOL

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Russ - 19 Aug 2007 05:00 GMT
Steven,
You unprotect to insert your data gleaned from userforms or user formfield
choices, then immediately re-protect. The speed at which that happens should
be safe, unless they abort the macro doing the insertion of data while the
document is unprotected. Code like this example from VBA Help can keep the
user from using the abort macro keys.

Application.EnableCancelKey = wdCancelDisabled
For i = 1 To 10000
   StatusBar = i
Next i
Application.EnableCancelKey = wdCancelInterrupt

> I'd like to keep the document protected in an effort to keep the user
> (employee) from taking out too much information from the report.  Believe it
[quoted text clipped - 38 lines]
>>
>> Why don't you want to unprotect it?

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.