Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Stone Ridge, New York, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tracked Changes in Protected Form (Word 2000)

    Hi, Does anyone know a way to be able to use Tracked Changes in a protected form? Thanks, Sherry

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

    Re: Tracked Changes in Protected Form (Word 2000)

    Protected how? You mean the form is protected from changes except for the fields? That would be Tools - Protect Document - Forms. In that case the user can not make changes except to the form fields, so there can't be any changes to track. There is also Tools - Protect Document - Track Changes. I have never used this but it looks like it forces changes to be tracked, since it grays out the check box to turn off track changes. More detail about the problem please.

  3. #3
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Tracked Changes in Protected Form (Word 2000)

    You will need to turn on revision tracking before the form is protected for forms. Once it is protected it can't be additionally protected for revisions. Trying to do so with VBA just gives an error.

    Therefore you need to turn off the Forms Protection, turn ON the revision tracking and then turn ON the Forms Protection again. If you need to preserve the contents of the fields you will need a macro to ensure the fields are not wiped when unprotecting/protecting a form. That macro has been posted previously.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  4. #4
    Star Lounger
    Join Date
    Apr 2002
    Location
    Stone Ridge, New York, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracked Changes in Protected Form (Word 2000)

    My template consists of a table with rows, each row being a new Section. alternately protected/unprotected. The protected rows (Rows/Sections 1, 3, 5, etc.) each contain one dropdown combo box - the unprotected rows (Rows/Sections 2, 4, 6, etc.) are unprotected text sections where the User basically types narrative.

    It is for those unprotected narrative text sections that I need Tracked Changes to function. So far, whatever I do - including the Tools Protect/Unprotect Document and Protect Forms macros - has resulted in the dropdowns not functioning or entirely disappearing when a new choice is made.

    And - while I have you here - if you don't mind - do you know the best way to navigate from a protected formfield into an unprotected non-formfield area and then back into a formfield (Dropdown to Narrative to Dropdown to Narrative, etc.)? That's my other stumper :-)

    THANKS
    -Sherry

  5. #5
    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: Tracked Changes in Protected Form (Word 2000)

    No, I think the closest you can get is to turn on tracked changes and protect for Forms (carefully identifying the sections to be protected). In my test, the form elements work AND I cannot turn off the tracking of changes unless I unprotect. In this setup my drop-downs look fine, but textboxes are marked with changes. Not pretty, but reasonably functional.

    Rats... as I was trying to create a screen shot for you, I lost the drop-down control. Back to square 1.

  6. #6
    Star Lounger
    Join Date
    Apr 2002
    Location
    Stone Ridge, New York, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracked Changes in Protected Form (Word 2000)

    The Dropdowns seem fine until you try to make a choice other than the default. Then, first it doesn't change from the default, and then if you try it again, the whole field disappears. Weird. I think, from some testing, that the change in the Dropdown choice is a being picked up by the Tracked Changes and that is what is causing it to disappear. But I'm not enitrely sure about that - just a hunch. I'm wondering if there's a macro I can use that will stop the Tracked Changes from having any effect on the dropdowns...

    Thanks for taking the time,

    Sherry

  7. #7
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Tracked Changes in Protected Form (Word 2000)

    This document sounds like a problem to manage. Are you sure Word is the best program for this? Are you sure that the text entry points have to be unprotected sections? And tracking changes on top of this!!! <img src=/S/duck.gif border=0 alt=duck width=23 height=23> I can hear trouble brewing.

    You could code OnEntry and OnExit macros for each of your dropdowns to turn off or on the revision tracking. The On Exit macro could also be used to put your cursor in the following unprotected section too as per your earlier question.

    The complexity of this document means that you are digging yourself deeper and deeper into work and maintaining this file is perfect if you are a contractor on an hourly rate <img src=/S/money.gif border=0 alt=money width=17 height=15>. If not then I would suggest you try to find another way of approaching this problem. For instance, what do you do with the data that is collected? How do you use the revised information? Is it necessary to collect in one file or can a SaveAs give you a more useful data source.

    Have you investigated Autotext Lists as a way of getting a simple dropdown without the overheads? Ask fields might be usable too. Or maybe a userform Wizard to assist in updates.

    I guess what I am trying to say is that the multiple section way you described the form sounds complicated to build initially and very difficult to maintain. I always try to go with either a fully protected file or a non-locked file. Both have disadvantages but are a truckload simpler.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

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

    Re: Tracked Changes in Protected Form (Word 2000)

    I agree with Andrew. Word Tracked changes doesn't work very well, and really doesn't work very well with tables. You need to do it some other way than Word.

Posting Permissions

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