Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Can't unlock a form (Word 2000)

    I created a form using Word's Form Fields. When I retrieve it, the Control Toolbox toolbar and Forms toolbar are entirely grayed out. How do I unlock it? (I've attached the file.)

    I think I may have saved and closed the form in locked mode. Does that make it forever locked?

    I have several other copies of the document which fortunately don't have this problem, but I'm hoping to find out why this one has a problem.

    Also, I have another copy of the form that has this same problem, but when I did a Save As and created a new copy, the copy was unlocked and was in Design mode, so it's okay. I'm confused.

    Russ
    Attached Files Attached Files

  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 unlock a form (Word 2000)

    The lock button on the Forms toolbar should be enabled. If not, it's mostly the same thing as Tools > Protect and its alter ego, Tools > Unprotect. Is one of those enabled?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't unlock a form (Word 2000)

    As Jefferson pointed out, the Lock button on the Forms toolbar should be enabled - it is for me if I open your document.

    Just in case you can't make it work, I have attached your document unlocked, but without other modifications (in a zip file to save bandwidth)
    Attached Files Attached Files

  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: Can't unlock a form (Word 2000)

    Interesting. I can open the document so that I can access the lock on the Forms toolbar & I can open it so that I can't. When I open the document, I get a message that it contains macros & asks if I want to enable or disable them.

    1. If I choose enable, I can unlock the form either through the menu or the Forms toolbar. However, I have trouble scrolling through the document. It redraws slowly so that it appears there are "waves". If I unprotect the document, the Control Toolbox becomes available too.

    2. If I choose disable, the lock on the Forms toolbar & all the other buttons on the Forms toolbar & the Control Toolbox are greyed out. I had no trouble scrolling, however.

    3. If I place the document in my templates folder & open it from there (so there is no message), I still have the scrolling problem, but again, I can unprotect the document.

    If I open the VBE & go to ThisDocument & double click, I get:
    Private Sub CheckBox2_Click()

    End Sub

    However, I don't know what that means. Maybe one of the VBA experts can use these clues?
    I could find no modules in the document using the VBE. I wonder if you somehow disabled the Forms Toolbar (& some other options) when you created the form.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't unlock a form (Word 2000)

    Hi Phil,

    The empty CheckBox2_Click is an event handler that was never completed. But even if you remove that, you'll get the macro warning. This is because the document contains controls from the Visual Basic Toolbox. Even if there is no code involved, Word installs the macro components in the document.

    If Russ Kidd has macro security set to high he won't get the prompt, and macros will be disabled. That might well be the cause of the behavior he sees.

  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: Can't unlock a form (Word 2000)

    Thanks for the explanation, Hans. I take it that there is no way to remove the macro components other than to copy the text to a new document, then?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't unlock a form (Word 2000)

    In Word 97, it wasn't possible to remove the macro components completely once they had been installed, but in Word 2002 (and I thought in Word 2000 too), they will be removed automatically if you remove ALL code (including code in ThisDocument) and ALL userforms and ALL controls created from the Control Toolbox. (Formfields created from the Forms toolbar don't count)

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

    Re: Can't unlock a form (Word 2000)

    I went to the VBE & removed all code from ThisDocument. I could find no UserForms or Controls. Still get the macro warning, so maybe it didn't change until Word 2002.
    Cheers,

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't unlock a form (Word 2000)

    Did you remove the check boxes in the document itself? They are VB check boxes, not formfields.

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

    Re: Can't unlock a form (Word 2000)

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>. Now I did. And I don't get the macro warning any more. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  11. #11
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Can't unlock a form (Word 2000)

    Guys, thanks for the good feedback. Forgive the late response -- I've been swamped all day and am still buried in work. I'll examine what you've said as soon as I can.

    ...I've just added this -- I'm leaving the office now and will be back here Sunday. I hope to have time to respond more in detail.

    Russ

  12. #12
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Can't unlock a form (Word 2000)

    Guys - it's now Sunday, but we were swamped all day again. I'll respond first chance I get. Sorry.

    Russ

  13. #13
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Can't unlock a form (Word 2000)

    Jefferson, Hans and Phil,

    I finally had a chance to try a few things today based on your comments. I apologize again for the delay. We've been inundated with work for several days. So in case you haven't entirely lost interest, here are some results:

    First, Jefferson, the lock button on the Forms toolbar was grayed-out as was everything on both the Control Box toolbar and the Forms toolbar, so I could not enable or disable anything.

    Next, just out of curiosity, I tried saving the document directly from the attachment on my original post. Surprisingly, the lock button on the Forms toolbar was no longer grayed-out, so I could unlock the document. (By the way, my macro security level was set to High.)

    Then, Hans, I tested your idea that my High security level might have been the cause of everything being grayed-out on the original problem document. I reset the security level to Medium, then retrieved that original problem document. Sure enough, the lock button on the Forms toolbar was not grayed-out, so I could unlock the document.

    My theory is that the reason I had the original problem was that I locked the document, then saved and closed it. I say this because I made other copies of the document as backups before I locked, saved and closed it, and none of them had this problem. My macro security level was set to High during all of this.

    I'm a beginner when it comes to macros, so your discussion of them was beyond me.

    Thanks to all of you for your help. Each of you has helped me numerous times in the past and I appreciate it.

    Russ

Posting Permissions

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