Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Check Boxes in an unprotected document (Word 2003)

    i'm on a roll with issues at the moment. Here goes again.

    I created a series of forms using fields in a locked document. I managed to get over the issue of no spellchecking using a macro I found a MVPS. I am now having trouble with users locking and unlocking the form and getting completely confused. I know I could password protect the protection, but I dont want to head down that path without exploring other options.

    The reason I made protected templates in the first place was so that users can tab through fields and click on check boxes. It seems now they are findng the fields restrictive and would prefer the freedom to format text, cut and paste and add boxes to tables. That leaves the issue of check boxes. We still need the ability to check YES or No for many questions.

    I have attached an extract to illustrate what I am dealing with.

    I found an article by Charles Kenyon that describes using macrobuttons, but I found it difficult to decipher.

    Help!
    Attached Files Attached Files

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

    Re: Check Boxes in an unprotected document (Word 2003)

    It's possible to protect only some sections of a document for forms. The user can freely enter and format text in unprotected sections. However, this will not work well in your current document - some rows of the table contain both text fields and check boxes, but you cannot place a section break between cells in a row. You might be able to use this if you reorganized the layout.

    Another possibility is to use option buttons from the Control Toolbox. In the attached document, I have deleted the text fields and replaced the check boxes with option buttons. I have set the GroupName property of each pair of option buttons to the same name in the Properties window, so that the pairs act together - if you select one, the other is automatically cleared.
    The disadvantage of items from the Control Toolbox is that they cause a macro warning.
    And since the document is now unprotected, it is very easy for the user to mess it up.

    Note: to edit controls from the Control Toolbox, you must turn on design mode. This is toggled on and off by the first button on the Control Toolbox. The second button activates the Properties window.
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Check Boxes in an unprotected document (Word 2003)

    Hmmmm, not baaad.......... here are my thoughts - I welcome discussion

    A little fiddly to set up, as each set of radio buttons have their own number. But I could do it. Could a macro button do the same? Then I could copy and paste it through out the document. Only issue though I thought of with macro buttons though, is that the user can delete it as easily as hitting the space bar. And I dont know how to create that looks like your radio buttons - that is using both yes and no.

    What do you mean when you say "And since the document is now unprotected, it is very easy for the user to mess it up." what would you imagine they would mess up?

    Wouldnt it be great if Word had allowed the ability to lock a cell within a table!

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

    Re: Check Boxes in an unprotected document (Word 2003)

    I only set up the groupnumbers to make the option buttons behave as pairs. You could use check boxes instead; they would behave just like the ones you originally had, allowing the user to tick none, either one or both of a pair.

    > the user can delete it as easily as hitting the space bar

    That is true for anything in an unprotected document - the user can delete the entire table with Alt+5 followed by a space. This is exactly what I meant by " it is very easy for the user to mess it up".

  5. #5
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Check Boxes in an unprotected document (Word 2003)

    Ok I see now. Yeah.... I REALLY like the Control Toolbox idea. I think I will go with it. See my change to two tick boxes.

    Now that you have me drooling for more on the things I could do with the Control Toolbox, can you tell me how I would use a dropdown list? I mean how do I put the selections into the list?

    <img src=/S/joy.gif border=0 alt=joy width=23 height=23>
    Attached Files Attached Files

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

    Re: Check Boxes in an unprotected document (Word 2003)

    You have to run VBA code when the document opens to populate the combo box (dropdown list). The following code should go into the ThisDocument module (not into a standard module):

    Private Sub Document_Open()
    With Me.ComboBox1
    .AddItem "This"
    .AddItem "That"
    .AddItem "Other"
    .AddItem "None"
    End With
    End Sub

Posting Permissions

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