Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disappearing drop-down list selections (2000/SR-1)

    I created a form in Word 97 using drop-down lists. I am now using Word 2000. (Note: I don

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing drop-down list selections (2000/SR-1)

    Hi Ruth:

    You're not doing anything wrong. When you protect a form, the formfield is reset & all data is lost. You can prevent this from happening to a text form field by locking the field (Ctrl+F11) before reprotecting it. However, you can't prevent drop down & checkbox fields from resetting using this method.

    The only way to prevent this from happening is to change the commands with a macro or provide a separate macro for users to protect the form without resetting the fields.

    I use this macro from Cindy Meister's home page at <A target="_blank" HREF=http://homepage.swissonline.net/cindymeister/FormFram.htm>http://homepage.swissonline.net/cind...r/FormFram.htm</A>:

    Sub ToggleFormProtect()
    If ActiveDocument.ProtectionType = wdNoProtection Then
    ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True
    MsgBox "The document has been protected"
    Else
    ActiveDocument.Unprotect
    MsgBox "The document is now unprotected"
    End If
    End Sub

    If you have any questions about placing that macro in the attached template or assigning it to a toolbar button or shortcut key, please post back.

    Hope this helps.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Wisconsin, USA
    Posts
    193
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disappearing drop-down list selections (2000/SR-1)

    Phil -

    The macro is just what I've been looking for. So many times, people in other offices have called me because they reprotect document and loose everything they have put in. Now I have to figure out how to add it to a toolbar to keep it with template.

    Thanks, Leanne
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing drop-down list selections (2000/SR-1)

    Hi Leanne:

    To add the macro to a toolbar, after you've created it:
    1) choose Tools/Customize...commands tab
    2) In catagories, scroll to macros
    3) On the right-hand side, scroll to your macro (probably starts "TemplateProject.NewMacros.& then the macro name")
    4. Drag it to your toolbar & give it a shortname.

    That should do it. Hope this helps.

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Wisconsin, USA
    Posts
    193
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disappearing drop-down list selections (2000/SR-1)

    Hi Phil -

    I did get it added to my toolbar right after I read the post thi morning, tried it out on one of my templates and it works GREAT. Then I made the decision not to include it as a toolbar on our office templates for 700+ employees. I realize it would be nice for some people, but another toolbar popping up on someone's screen, well...is it worth all the calls I'd get asking what it's for? I don't think so. Until someone calls me with a question as to why they lost everything, I'll keep the gem to myself.

    Thanks again,
    Leanne <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing drop-down list selections (2000/SR-1)

    Hi Leanne:

    Just for your information, you can substitute some macros for basic word commands without your users even being aware of it. See <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q191/0/28.ASP>this</A> Knowledge Base article for instructions on how to modify the Tools/Protect & Unprotect menu option & the button on the forms toolbar, so users won't ever lose their data.

    Hope this helps.

  7. #7
    Star Lounger
    Join Date
    Feb 2001
    Location
    USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing drop-down list selections (2000/SR-1)

    Thanks Phil. I just made the areas where typing will be done, form fields. That seems to work. I am macro challenged, so I usually like to find other ways of doing things! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Thanks again for your help.

    Ruth

Posting Permissions

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