Hello,

I have created a form that is going to be used by many people on a daily basis, so it needs to be protected in order to prevent users from messing the form up. I have also added a command button that automaitcally prints and emails this form to the appropriate people. My problem is - when the document is protected, my command button does not work.

Also, under the craft person count table in the attached document, is there a way to have a calculate button, or a macro that will update the total fields?



Please help, I am sure this is a simple fix, but I am new to VBA. I have attached my form so you can see what I am working with.

Word 2010

Thanks,

Attached Files

Sample Form1.docx (63.2 KB, 11 views)

You could just check the formfields' "calculate on exit" property. No vba required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]