Make Word Form Available for Use on Home Page
How can I make a Word form available on an Intranet site for many to use without everyone having to reset their Macro security to Low (which is against company policy)?
Also - using an On Entry macro, this form "checks" certain lower level check boxs depeneding on which check box is checked at the top of the form.
How do I also change the color of the "X" in the check box at the time it is checked. Thanks for your help.
Sub FillForm()
'Check to see which checkbox is checked
If ActiveDocument.FormFields("Check1").CheckBox.Value = True Then
StdROW
Else
If ActiveDocument.FormFields("Check2").CheckBox.Value = True Then
CPROW
End If
End If
End Sub
Sub StdROW()
ActiveDocument.FormFields("Check7").CheckBox.Value = False
ActiveDocument.FormFields("Check8").CheckBox.Value = False
ActiveDocument.FormFields("Check9").CheckBox.Value = False
ActiveDocument.FormFields("Check3").CheckBox.Value = True
ActiveDocument.FormFields("Check4").CheckBox.Value = True
ActiveDocument.FormFields("Check5").CheckBox.Value = True
ActiveDocument.FormFields("Check6").CheckBox.Value = True
ActiveDocument.FormFields("Check10").CheckBox.Valu e = True
End Sub
Sub CPROW()
ActiveDocument.FormFields("Check3").CheckBox.Value = False
ActiveDocument.FormFields("Check4").CheckBox.Value = False
ActiveDocument.FormFields("Check5").CheckBox.Value = False
ActiveDocument.FormFields("Check6").CheckBox.Value = False
ActiveDocument.FormFields("Check7").CheckBox.Value = True
ActiveDocument.FormFields("Check8").CheckBox.Value = True
ActiveDocument.FormFields("Check9").CheckBox.Value = True
ActiveDocument.FormFields("Check10").CheckBox.Valu e = True
End Sub
|