Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Protect and Track Changes

Status
Not open for further replies.

DaveRolph

Programmer
Sep 12, 2001
26
GB
I am not sure if this is possible but here goes

Word 2000 Document with Form
Single Record Mail Merge (toggled to view on screen)

I want to track changes AFTER the record has been toggled, not to view the changes but save/accept the changes when saved.

The idea is that I want the users to complete the form (some of the data will be completed from the mail merge for them already) but protect the form AND have the ability of tracking the changes made by the user.

Is this possible ?

 
I have been playing with the Macro function and made some progress but not quite got the answer yet...

The following looks OK, opens but does not accept / save my changes, obviously because no changes have been made when it opens, I think I am close please can anyone help ?

Is there a on close function I can use ?

Code:
Sub AUTOOPEN()
    Call MAIN
End Sub

----------------------------------
Sub UNPROTECTFORM()
    ActiveDocument.Unprotect Password:="RAINBOW"
End Sub
----------------------------------

Sub ACCEPTANDPROTECT()
   ActiveDocument.AcceptAllRevisions
   ActiveDocument.Protect Password:="RAINBOW", NoReset:=False, Type:=wdAllowOnlyFormFields
End Sub
----------------------------------

Sub TRACKON()
  With ActiveDocument
  .TrackRevisions = True
  .PrintRevisions = False
  .ShowRevisions = False
  End With
End Sub
----------------------------------
[b]
Sub MAIN()
  Call UNPROTECTFORM
  Call TRACKON
  Call ACCEPTANDPROTECT
End Sub[/b]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top