protected form - can't edit text box in unprotected section

P

patmoore

I have the task of recreating a form in a specific format. It is a
fill-in-the-blanks on-screen (not on-line). I am pretty much a newbie
at form creation and have very little experience with VBA but with
decent instructions I'm willing to try anything. The form creation is
going fairly well, but the problem is that the person who has asked me
to do this is absolutely dead set on there being a text box in the
center of page one, which is a fixed size, and which is then linked to
a text box on a second page in case the discussion runs over the max
fixed size of the text box on page one. Before and after the text box
on page one are several boxes to click and insert short pieces of
information. This form must be protected so the inexperienced user
cannot inadvertently change the format.

My problem arises from the conflicting need to protect the form and to
have (linked) text boxes. I have split the form into four section,
and have protected sections 1 & 3 only, but after protection is on,
cannot type in the text box. The only reason I am using text boxes is
the need to have text flow from the middle of page 1, past the next
section of fill-in-the-blanks, to the linked text box on page 2. If
there is any other way to do it, I haven't yet figured it out. HELP?
(and remember I am very new to VBA).
 
S

Suzanne S. Barnhill

I don't suppose it would do any good to tell this demanding person that what
he/she wants can't be done?

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

TF

What the person wants and what the person gets are mutually incompatible.
Just tell it straight - no can do.

--
Terry Farrell - Word MVP
http://www.mvps.org/word/


I have the task of recreating a form in a specific format. It is a
fill-in-the-blanks on-screen (not on-line). I am pretty much a newbie
at form creation and have very little experience with VBA but with
decent instructions I'm willing to try anything. The form creation is
going fairly well, but the problem is that the person who has asked me
to do this is absolutely dead set on there being a text box in the
center of page one, which is a fixed size, and which is then linked to
a text box on a second page in case the discussion runs over the max
fixed size of the text box on page one. Before and after the text box
on page one are several boxes to click and insert short pieces of
information. This form must be protected so the inexperienced user
cannot inadvertently change the format.

My problem arises from the conflicting need to protect the form and to
have (linked) text boxes. I have split the form into four section,
and have protected sections 1 & 3 only, but after protection is on,
cannot type in the text box. The only reason I am using text boxes is
the need to have text flow from the middle of page 1, past the next
section of fill-in-the-blanks, to the linked text box on page 2. If
there is any other way to do it, I haven't yet figured it out. HELP?
(and remember I am very new to VBA).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top