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 / December 2006

Tip: Looking for answers? Try searching our database.

Prompting User to fille in fields when document is opened.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GuyInTn - 20 Dec 2006 13:27 GMT
Hello all,

This is a two part question.

1. How can I create a document that will ask the user a series of
questions when they open the document and then populate the document
with those answers?

2. How can I protect the other parts of that document so the user
cannot edit the other content?

Thanks,
Chris
GuyInTn - 20 Dec 2006 13:33 GMT
I forgot to add that I am using Office 2007.

> Hello all,
>
[quoted text clipped - 9 lines]
> Thanks,
> Chris
Malcolm Smith - 20 Dec 2006 18:16 GMT
Chris

For the first part look at:
http://www.dragondrop.com/wordcoding/word011a.asp

- Malc

> *From:* "GuyInTn" <mcgrathc@gmail.com>
> *Date:* 20 Dec 2006 05:27:26 -0800
[quoted text clipped - 12 lines]
> Thanks,
> Chris
src - 20 Dec 2006 20:12 GMT
Hi Chris,

I can help with #1:

I've done this two ways.  The simple way, for just a few fields is to
set up several ASK fields.  These will be hidden from view but can be
seen with Show/FieldCodes.  The info will be saved in a bookmark and
you can insert Cross References throughout your doc.  When you need to
update the data, you select the line with the ASK fields and then F9
(Update).  You'll then need to update all the cross references too.  I
did this with a single macro that I recorded that simply did: CTRL-A
(select All), F9 (update).

The next way I did this (and am much happier with) is to use a UserForm
and store the data in Custom Document Properties.  This makes for a
nicer user interface (instead of a series of pop-up dialogs), and much
nicer code control with VBA.  You can still insert cross references by
Insert>Field>DocProperties (I did this with an "insert x-ref" button on
my UserForm).

For #2, I do know you can protect parts of a document based on
Sections.  You can also toggle protection with VBA commands.

Hope this helps!

> Hello all,
>
[quoted text clipped - 9 lines]
> Thanks,
> Chris

Rate this thread:






 
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.