Clearing Checkboxes in Form using Macro (Protected Form)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryan.mae.casey@gmail.com - 10 Nov 2006 22:21 GMT

Hi All,

I created a form and I have the macro to unprotect the document, clear
the "text" type fields & re-protect, however, the check boxes do not
clear. This is what I'm currently using & it's working wonderfully on
the text fields, but no such luck with the check boxes.

Sub Clear()
With ActiveDocument
.Unprotect Password:=""
.Range.Fields.Update
.Protect _
Type:=wdAllowOnlyFormFields, _
NoReset:=True, _
Password:=""
End With
End Sub

Any help would be greatly appreciated!

Reply to this Message

Doug Robbins - Word MVP - 11 Nov 2006 00:57 GMT

All you need is

With ActiveDocument
.UnProtect
.Protect wdAllowOnlyFormFields
End With

That will clear everything. Using NoReset = True prevents things from being
cleared.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi All,
>
[quoted text clipped - 15 lines]
>
> Any help would be greatly appreciated!

Reply to this Message

ryan.mae.casey@gmail.com - 13 Nov 2006 15:03 GMT

Silly me!! Thanks so much for your help!!!

Reply to this Message

Rate this thread: