Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Atlanta, GA
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disappearing data (Word 97)

    I created a protected form using the Text Form Field button for data entry in various cells. I protect the file using the Tools Protection Protect Document command. Everything works great until I unprotect and reprotect. When I do this, all my entered data disappears.

    I tried using Sections to create the form but because there are protected and unprotected cells on the same lines it was very awkward. The Text Form Field seemed to work until everything vanished. Can someone help?

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

    Re: Disappearing data (Word 97)

    The only way to reportect a form without losing all the data in the FormFields is with VBA.

    ActiveDocument.Protect wdAllowOnlyFormFields, true
    --
    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

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Atlanta, GA
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing data (Word 97)

    Thanks.

  4. #4
    New Lounger
    Join Date
    Nov 2002
    Location
    Belleville, Illinois, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing data (Word 97)

    One option is to lock the fields before you reprotect the form. You can select individual fields and do a CTRL+F11 or Select All (CTRL+A) and do a CTRL+F11. To unlock the fields CTRL+SHIFT+F11.

    Gerry <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

Posting Permissions

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