Results 1 to 11 of 11
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't Touch This! (2000/SR-1)

    I have two types of Word contract "forms" which I distribute to the field. One uses ASK fields and REF fields to bookmarks to fill in information like the other party's name, and the other has a userform that does the same thing with textboxes and radio buttons and so on, for more elaborate contracts. This is for generating standard forms like a Confidentiality and Non-Disclosure Agreement without having to go through Legal (that's me). I have the forms protected as forms and I also protect my AutoOpen macro code with a password. I do not want people having access to the text to make unauthorized changes. I was experimenting to see how that could be done and discovered that if the doc is saved as an RTF file, and then opened with Word, it still was locked (i.e. you can't select text), which is a nice feature. However, if I open the RTF file with WordPerfect (and presumably with other wp programs), I have a good revisable doc with formatting that it is the same or close to the original. I think I am willing to accept this risk, but I am wondering if I have done all I can to "lock up" the docs.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Can't Touch This! (2000/SR-1)

    I wonder if you could somehow incorporate a checksum into a field code that would make the document "tamper evident." I've never had to figure out a checksum algorithm, so I really don't have any idea whether it could be done.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    Well,

    If you want to prevent the users from using the SaveAs command to save it as an RTF file, or any other file type for that matter, you can add this sub to your document to "disable" the Save As Command:
    <pre>Sub FileSaveAs()
    End Sub</pre>


    Your user will be able to save it as a document, but will not be able to use Save as.

    Once the doc is in it's completed state, you could do an MD5 checksum on it. That will give you a long string of characters. Then later on down the road, if you want to verify that it hasn't been tampered with, you do another MD5 checksum on it again and compare the two. If they are the same, then it hasn't been tampered with.

    If you want more info on MD5, your best bet it to do a google search on MD5.

    HTH,
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    If a user saves as RTF, that gets rid both of all macros (and any additional protection you have established with macros) and of the password protection (so you can just remove the protection in Word and copy/paste/edit everything).

    I don't think there is a way to prevent manipulation of your original text (which is what you are worried about, if I understand it).

    Checksums on the file probably won't help, because the files will have to be altered if the user enters information. I don't know the legal aspects if a user changed the text, so that the things he agreed to are different from your original.
    In principle, this probably came up with written contracts, too. Electronic files have the advantage that you can (if you think it necessary) compare your text in the returned form with the original automatically: It shouldn't be too much trouble to write a macro that compares the two files and ignores the user input. Though I don't know if it is necessary, and worth the trouble.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Klaus

  5. #5
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    Thank you all for your ideas! My post was not clear. We have several offices throughout the country. Legal at corporate headquarters has a form, let's say a Confidentiality agreement, which is distributed as a form to our several offices. We want the contracts to be uniform and we do not want people in the field to make the decision about changing some wording here and there, and perhaps messing up our exquisitely crafted weasel words. If changes are requested, we want them to come back to Legal, not do it themselves or let the other party do it. If I am sending a contract to the other party (and we have finished negotiating the terms) I use Adobe Acrobat and protect the document so the text can not be "re-purposed". In other words, I am trying to protect my own internal procedure, which is, if there are any changes from the approved form, you have to go through Legal.

  6. #6
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    OK, that's a bit different.

    If it is a TRUE form, with Form Fields on it. Just Protect the form with a password.

    Turn it into a template and distribute the template.

    Then when the end-user creates a new agreement, all they will be able to do is fill in the blanks you provided for them in the template.

    Is this the kind of idea you are after?
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  7. #7
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    Thanks! I put this in my code and it works great. I had no idea it was this easy to disable a command. Of course, it makes it impossible for me to save the revised form doc, also. I discovered you can, however, still save the doc with the VBA Editor File Save. I hope somebody gets the "error message" and calls me!

    Sub FileSaveAs()
    MsgBox "Sorry! File Save As is not working today." & vbNewLine & vbNewLine & "Try again next week maybe."
    End Sub
    Sub FileSave()
    MsgBox "Sorry! File Save is not working today." & vbNewLine & vbNewLine & "Try again next week maybe."
    End Sub

  8. #8
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Can't Touch This! (2000/SR-1)

    Well, if you want to give 'em something to talk about, try this:

    MsgBox "Document secured. To obtain the password, email bill.gates@microsoft.com immediately."

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  9. #9
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    When I tried this (Word 97) it disabled the menu options to save but I could still alter the text AND keep my changes if I said yes to the save changes message? when I closed the document.

    Is there some equally trivial code to disable that option as well?

    stuck

  10. #10
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    Have a look at <post#=177864>post 177864</post#>. It should give you what you need.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  11. #11
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Touch This! (2000/SR-1)

    I'm pretty sure this code completely disables all file saving.
    My form uses ASK fields and bookmarks and REF fields to obtain and
    plug in variable information like the name of the other party to the contract.
    I assume it would work with a form using any other kinds of form fields.
    Password protect both the form doc and its macro code.

    Sub AutoOpen()

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •