Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Handling Lengthy Text in Excel?? (Excel 2000)

    I have been asked to make a template that will contain formulas that must be protected because some of the users have limited computer skills. The template also contains several areas where the user must type large amounts of explanatory text (which may vary from one sentence to several paragraphs).

    I do not know how to handle large amounts of text in Excel. If I protect the form, it disables the user's ability to re-size the row height in order to display all the text. Protecting the form also disables their ability to insert additional rows (and an Excel cell will only display 1,024 characters). I thought about using a text box instead of a cell, but protecting the worksheet also disables their ability to enter the text or re-size it.

    If I tell them to unprotect the form to make the necessary row-height adjustments, I **KNOW** they will not remember to protect it back, and they may accidentally delete the formulas in the process.

    Any suggestions on how to handle this would be greatly appreciated!!! I am unaware of any other options available to me.

    Thanks,
    Jessi

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Handling Lengthy Text in Excel?? (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Jessi

    OK I had asked the very same question a couple of weeks ago. I will dig the message number and send it to you so that you can look at the thread.

    I would suggest, as it was pointed out in my replies, is to shell into MS-Word, have the user enter the text in MS-Word, which is the ideal situation if you know VBA and automation.

    If not, you can still use textboxes, just make sure that when you protect the worksheet you do not protect Objects, and that will allow you to work with the textboxes independatly.

    Start working with VBA, and you can see how much you can do with it. Its pretty neat, and I am sure you will like it.

    If you need any help, please reply to this message.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Aug 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Handling Lengthy Text in Excel?? (Excel 2000)

    Okay... I would very much like to read your previous message thread. Although my current skill level with VBA is very, very limited, I have just enrolled in a Visual Basic class. I would really like to figure this out and impress my boss... ha! ha!

    Thanks,
    Jessi

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Handling Lengthy Text in Excel?? (Excel 2000)

    Hi Jess,

    You could also try giving the users one or more defined areas (eg shaded merged cells spanning multiple columns/rows with text wrapping turn on) to type in, and leaving those cells unprotected. Done right, you'll give everyone enough space for the what's needed whilst curtailing those inclined to write tomes.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    New Lounger
    Join Date
    Aug 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Handling Lengthy Text in Excel?? (Excel 2000)

    Thanks, everyone! This is a great resource... I'm glad I found it. There are three sections, one right after the other, that require text responses. To save paper and file space, the boss wanted the next section to immediately follow the previous one, which means the row height would need to adjust accordingly. On my version of Excel (2000), if you protect the worksheet you can't adjust the row height (even if you unlock a particular cell)... I'm not sure how this works on other versions.

    Today, I tried Wassim's earlier suggestion: I put all three sections in one big text box and left the "objects" option unprotected when I protected the worksheet. The user will have to move their cursor beneath each section's appropriate response line to begin typing, but at least they can adjust the size of the text box when they are through. We'll see how this works. (I hope there are no limits to the size of a text box!!)

    Thanks again, everyone!
    Jessi

Posting Permissions

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