Calculate fields in a protected form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

e oman - 28 Aug 2007 16:32 GMT

How Can I calculate fields in a protected form. I have an employee
evaluation in a Word2007 document using fields in a table. I have the "math"
entered in the table an a macro to "select all" and F9 to calculate the
scores BUT I want to protect the form so that only the ratings are entered by
the supervisor and they are unable to change the descriptions or weights. As
soon as I protect the form (allowing form fill-in) the macro becomes
unavailable. Also I am unable to "select all".

Signature

Ed O

Reply to this Message

macropod - 29 Aug 2007 00:26 GMT

Hi Ed,

Instead of using a macro, why not use each formfield's 'calculate on exit' property?

Cheers

Signature

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

> How Can I calculate fields in a protected form. I have an employee
> evaluation in a Word2007 document using fields in a table. I have the "math"
[quoted text clipped - 3 lines]
> soon as I protect the form (allowing form fill-in) the macro becomes
> unavailable. Also I am unable to "select all".

Reply to this Message

e oman - 29 Aug 2007 13:30 GMT

Thanks! Yes that works. Unfortunately I did not use the legacy tools and
the new form fields do not support that option but I can go back and change
the forms. Thanks for your quick reply.

Signature

Ed O

> Hi Ed,
>
[quoted text clipped - 8 lines]
> > soon as I protect the form (allowing form fill-in) the macro becomes
> > unavailable. Also I am unable to "select all".

Reply to this Message