Document Protection & Ask / Field Codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Wood - 07 Dec 2007 14:48 GMT

We have recently discovered the feature of allowing edit regions in a
protected document - brilliant!

We use "Ask" & "Field" codes heavily in our letters, we have allowed edit in
all Ask & field (bookmark) codes, hidden the codes then proctected the
document.
Normally, the users CTRL-A to select all, then F9 to activate "Asks".

This does not work on protected documents.

Is it meant to be used this way? Is it possible? If so how?

Thanks in advance for any assistance given.

Reply to this Message

Graham Mayor - 07 Dec 2007 15:40 GMT

Protected fields are frequently unnecessary in a letterhead template,
however if you must have them, youy are going to have to lock and unlock
your code in order to run functions that are not allowed when the document
is locked. The basic concept is covered at
http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm

Rather than cue CTRL+A then F9, you might find the update code at
http://www.gmayor.com/installing_macro.htm more useful. You can also run it
on exit from a form field.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> We have recently discovered the feature of allowing edit regions in a
> protected document - brilliant!
[quoted text clipped - 9 lines]
>
> Thanks in advance for any assistance given.

Reply to this Message

macropod - 07 Dec 2007 19:49 GMT

Hi David,

Since you're using protection, the simplest solution might be to replace any ASK or FILLIN fields with Text or DropDown formfields
located where you want the user's input to appear, then protect the document for forms. If you set the formfield properties to use
the same bookmark names your ASK fields set, then any cross-references to them will still work, plus checking the 'calculate on
exit' formfield property will cause the cross-references to update without thee need for CTRL-A then F9.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

> We have recently discovered the feature of allowing edit regions in a
> protected document - brilliant!
[quoted text clipped - 9 lines]
>
> Thanks in advance for any assistance given.

Reply to this Message

David Wood - 13 Dec 2007 12:55 GMT

Hi Macropod,

I can see that your logic is perfect here so I guess I must being missing
something obvious...

I have tested this with a single Ask;

ask NAME1 "name of officer dealing"

On the text form field options I have labelled the bookmark NAME1 and check
"fill in enabled" and "calculate on exit"

I then protect the document and reopen it. Press TAB key and get the prompt
"Name of Officer Dealing", enter some data and click OK..

The text entered does not reflect in the text form field no matter what I
try to do.

Am I missing something obvious here?

Thanks again

David

> Hi David,
>
[quoted text clipped - 17 lines]
> >
> > Thanks in advance for any assistance given.

Reply to this Message

Graham Mayor - 13 Dec 2007 15:48 GMT

The plan was that you removed the ASK field altogether and entered the text
directly in the TextForm field. Any cross references to that form field
would then be updated.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi Macropod,
>
[quoted text clipped - 51 lines]
>>>
>>> Thanks in advance for any assistance given.

Reply to this Message