Drop-down box results create multiple tables?

[Steven]

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]

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 ),
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]

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

Why don't you want to unprotect it?


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Steven]

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 :

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]

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

Why don't you want to unprotect it?


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Brian]

A slight increase in staff turnover may have the desired effect.
--
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
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 :

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]

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

Why don't you want to unprotect it?


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Russ]

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
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 :

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]

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

Why don't you want to unprotect it?


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Jean-Guy Marcil]

Brian was telling us:
Brian nous racontait que :

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

LOL

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org