Group: microsoft.public.word.vba.general
From: =?Utf-8?B?TGVubnk=?=
Date: Wednesday, March 26, 2008 5:43 PM
Subject: Re: Locking form fields in a protected Word template (Word 2003)

Hello macropod!
Could I code the 'lockdown' generically? As in thru a checkbox entry macro
and how would the code look? i.e., " [ ] Secure section here" also probably
another checkbox to unlock for edits? I love your simple solution.... and
here is the 'but'

There are way too many supervisors / employees to 'hardwire' in usernames

regards Lenny

"macropod" wrote:

> Hi Lenny,
>
> You could use an auto macro to test the username and, if it:
> .. is not the supervisor's username, the macro could turn off the "fill-in enabled" property for the supervisor-only fields.
> .. is the supervisor's username, the macro could turn on the "fill-in enabled" property for the supervisor-only fields.
> You'd need to have the supervisor's username hard coded or stored in the document properties.
>
> You could also use the same technique to lock supervisors out of the employee-comment areas too. Coded correctly, only the employee
> and their supervisor would be able to make any edits - others would effectively have read-only access only.
>
> Cheers
> --
> macropod
> [MVP - Microsoft Word]
> -------------------------
>
> "Lenny" wrote in message news:5796709F-B53F-4106-96EB-23A95514AC1D@microsoft.com...
> >I am setting up a performance review form where the supervisor selects a
> > rating from a dropdown and can add comments in a table cell directly below
> > based on the performance criteria.
> >
> > There is a section for the employees responses.
> >
> > Is there a way to programatically lock down the fields in the supervisor
> > section so the employee cannot change any of the comments or ratings?
> >
> > I have section breaks dividing the various inputs into protected and
> > unprotected sections to allow for the use of spell check.
> >
> > Best regards... Lenny
>
>