My document does have other macros in it. Does that mean I can't use the calculation feature in the fields? I created the following calculation (made sure it worked in Excel before transferring over to Word).
=IF(Cycle="Annually", "Year1"/1, IF(Cycle ="Semiannually", "Year1"/2, IF(Cycle ="Quarterly", "Year1"/4, IF(Cycle ="Monthly", "Year1"/12, IF(Cycle ="Bimonthly", "Year1"/6, IF(Cycle ="Triannually", "Year1"/3,0))))))
When I protected the document and tabbed through the fields, it skipped over the field with the formula and didn't calculate anything. Also, the default of the form field with the calculation was showing "$t:00" Which is another issue... I can't have anything showing as a default because if there isn't anything entered in the fields, I want the printed document to look like those fields don't exist.
Going back to the macro by Fumei - does "docFF" need to be changed to ActiveDocument.FormFields? since that is what I am referencing?
|