Danielbryanuk
Technical User
Hi there, I'd be very grateful if anyone can advise on the following issue?
I have created a form template in Word XP, which contains a table with simple formulas referencing other cells in the table. I have added fields to control user input, and have protected to document to restrict editing of anything else.
As with formulas in Word calculation is not automatic. To do this users must select the entire table and press F9, or right click the cell and update field.
However with a protected document users cannot select the "output" field cell to update, nor the entire table. As a work-around I created a macro in the form template as per the below, which is run on exit from a certain "input" field in the table.
Sub Updatetable()
' Updatetable Macro
Selection.WholeStory
Selection.Fields.Update
End Sub
The problem is that this method is not available with a protected document. Any ideas how I can update the table automatically, but keep the form template protected?
Thanks
Dan
I have created a form template in Word XP, which contains a table with simple formulas referencing other cells in the table. I have added fields to control user input, and have protected to document to restrict editing of anything else.
As with formulas in Word calculation is not automatic. To do this users must select the entire table and press F9, or right click the cell and update field.
However with a protected document users cannot select the "output" field cell to update, nor the entire table. As a work-around I created a macro in the form template as per the below, which is run on exit from a certain "input" field in the table.
Sub Updatetable()
' Updatetable Macro
Selection.WholeStory
Selection.Fields.Update
End Sub
The problem is that this method is not available with a protected document. Any ideas how I can update the table automatically, but keep the form template protected?
Thanks
Dan