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

    Protecting cells in table (Office 97)

    I created a form using several tables. How can I protect certain cells in a multitable document that I want to use as descriptions for the cells that follow.
    I tried to add "sections" but that did not work as I intended.

    Thanks for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Protecting cells in table (Office 97)

    Is this the effect you're looking for?

    This is done by putting a continuous section break at the beginning of the third table row, then clicking the Sections... button when I protected the document, to show that I only wanted to protect the first section.

    This was done with Word2000, but I'm pretty sure that this worked the same on Word97. (I saved it in Word 6.0 / 95 format to make reasonably sure).

    StuartR
    Attached Files Attached Files
    • File Type: doc x.doc (11.0 KB, 2 views)

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

    Re: Protecting cells in table (Office 97)

    Thanks for your reply. I did the same but what I need is to protect alternating cells in the same row. I am using one cell as a description of what must be input into the next cell. In Excel its as easy as pie. Surely there must be another way.

    Thanks again.

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Protecting cells in table (Office 97)

    Can you reorganise your information to use labels above instead of on the side?
    Can you use formfields for the cells that you want people to modify and use a single protected section (example attached)?

    StuartR
    Attached Files Attached Files
    • File Type: doc x.doc (11.0 KB, 1 views)

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

    Re: Protecting cells in table (Office 97)

    I guess the form field idea is more viable for me. Could you explain how you did it? Can these fields appear and print without any shading so they look like all other fields?

    Thanks.

  6. #6
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Protecting cells in table (Office 97)

    > Could you explain how you did it?

    View > Toolbars > Forms
    Move the cursor to where you want the Text form field
    Click on the Text form field button that looks like this ab|
    Right click on the new form field > Properties
    Type > Regular Text
    Default Text > "Type something here"

    > Can these fields appear and print without any shading
    I don't know any way to make them appear without shading, but the shading doesn't show when you print.

    StuartR

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

    Re: Protecting cells in table (Office 97)

    That's great! Now can you walk me through protecting the normal cells so that I leave the intergrated form cells free?

    Thanks.

  8. #8
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Protecting cells in table (Office 97)

    > walk me through protecting the normal cells

    This is the same document protection as you have already used. Tools > Protect Document... > Forms

    StuartR

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

    Re: Protecting cells in table (Office 97)

    Thanks.

    You have been very helpful. This looks like it could work. I'll give it a try on the whole form.

  10. #10
    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: Protecting cells in table (Office 97)

    Shading is a user-option, see Tools|Options...|View|Field Shading. You could reset this with a macro, but it is not document specific, so users might be annoyed...
    Attached Images Attached Images

  11. #11
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Protecting cells in table (Office 97)

    Jefferson,

    I tried using the Field Shading option before I wrote my last reply, it doesn't seem to affect the shading of Form Fields.

    StuartR

  12. #12
    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: Protecting cells in table (Office 97)

    You're right! I should have tested that before posting. I can banish the shading with this code:

    ActiveDocument.FormFields.Shaded = False

    which is the same as the second-to-last button on the Forms toolbar. But then I can't tell what's going on. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Attached Images Attached Images

  13. #13
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Protecting cells in table (Office 97)

    It's amazing, I must have looked at that button hundreds of times without noticing that I had never used it or thought about its function.

    Thank you.

    StuartR

Posting Permissions

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