Restricting individual form fields in word

However, itвЂ™s a good one to know when your hands are tied. I recommend using an Excel sheet instead of protecting a Word table in this manner, because this Word protection technique isnвЂ™t very flexible. If the document contains elements and text other than the table, Word protects everything but the Text Form Field controls. You can only select and input data in the cells containing a Text Form Field control. (In Word 2003, you can click Protect Form on the Forms toolbar instead.)ДЄfter enabling protection, Word wonвЂ™t let you select normal text. Editing Restrictions, and then click Yes, Start Enforcing Protection. In the resulting task pane, choose Filling In Forms from 2.In Word 2003, choose Protect Document from the Tools menu. Click Restrict Editing in the Protect group.Continue to select input cells and insert controls until youвЂ™re done.In Word 2003, display the Forms toolbar and click Text Form Field. In the Controls group, click the Legacy Tools option and choose Text Form Field.Field data can include lines of text, currency, dates and times, images and more. Select a cell where you want users to enter information. Learn about the difference between simple, calculated, and rollup fields.Create the table and enter the labels or values you want to protect as you normally would.To protect and unprotect cells in a Word table, do the following: The solutionвЂ™s a bit convoluted and works best with a simple document. Only those cells with the controls will allow changes. Protecting cells in a Word table isnвЂ™t as easy, but it can be done: you insert a Text Form Field control into each cell where you want users to input or modify values.

Protecting specific cells in an Excel sheet is easy. Protecting data in a Word table isn't as simple as turning a protection feature on, but it's possible using Text Form Field controls. You will need to decide the best course of action based on your needs, the data involved, and the type of users you have.How to protect cells in a Word table using a Text Form Field When the user tries to save or close the form, the AutoExit macro could check the value of the variable, and if it shows there are mandatory fields not filled in, then a dialog box explaining the problem could be displayed.ДЄll of these approaches, of course, will require extensive testing before implementing. Your macro, of course, could get much more specific in the checking it does.ДЇor a more comprehensive approach, you could have the on-exit macros (if there is more than one mandatory field) set a system variable. This particular example checks to make sure that the user enters something-anything-in the field. In this macro you would need to change the name of the field specified (Text1) to the name of the field you are using the macro with. SInFld = InputBox('This field must be filled in, fill in below.')ДЄctiveDocument.FormFields('Text1').Result = sInFld If ActiveDocument.FormFields('Text1').Result = '' Then The following is an example of a simple macro to do just this: If not, then the macro could move the insertion point back to the field to request input, or could prompt the user for the necessary information. (Right-click on the field, choose Properties, and use the Exit drop-down list to select a macro to run.) The macro could check to make sure the value provided within the field is within acceptable bounds. Perhaps the easiest method is to simply make sure that you set the appropriate 'on exit' setting for the form field to run a macro. But there are several ways to provide the same functionality. There is no setting that you can use to mark a field as mandatory, as you can in Access. In other words, making sure that the user must fill something in the field. Julia asked if there is a way, when designing forms in Word, to make a particular form field mandatory.

Restricting individual form fields in word