Calculate fields in a protected form

E

e oman

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".
 
M

macropod

Hi Ed,

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

Cheers
 
E

e oman

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.
--
Ed O


macropod said:
Hi Ed,

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

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

e oman said:
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".
 

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