+ Reply to Thread
Results 1 to 6 of 6

Embedded Word size limits?

  1. #1
    Registered User
    Join Date
    08-25-2009
    Location
    Albuquerque NM
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question Embedded Word size limits?

    I am trying to complete a form using Excel 2003. I have embedded a word doc into a large merged cell. Is there any way to limit the amount of text that the user can input into the word doc. When they put too much info inside it, the block starts to cover the cells below that cell and some of the users have a hard time with deleting the extra text and resizing the block. Is there ANY was to limit the size to the area provided in the form?

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Embedded Word size limits?

    There certainly isn't an easy way I can think of - it is after all a fully-functioning Word document. Is there a reason you can't use a plain text box, or just cells?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    08-25-2009
    Location
    Albuquerque NM
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Embedded Word size limits?

    The current workbook I have had out in the field uses regular text boxes in the merged cells, however, it is a report form where the employee types in a narrative. Sometimes the narrative is lengthy and excel for some unknown reason does not like huge cells filled with text. I also had to put in a spell check macro since I protected the form and some of the not so sharp knives in the drawer could use the hotkey I set up to run the spell check macro and I was not a sharp enough knife in the drawer to figure out how to create the toolbar button shortcutting to the spellcheck macro. Then, above everything else, most of the computers use office 2003 and there are a few that have office 2007 installed and the spell check macro will not work in the workbook at all. I uploaded the worksheet in the format I am using, the company info has been removed, but it shows the narrative block. I need to maintain the format to keep everything on one page for printing.

    I really appreciate any and all your help with this.
    Attached Files Attached Files

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Embedded Word size limits?

    Quote Originally Posted by mtraxscso View Post
    Sometimes the narrative is lengthy and excel for some unknown reason does not like huge cells filled with text.
    That's because it's not a word processor!

    I'll take a look at the workbook when I get a chance.

  5. #5
    Registered User
    Join Date
    08-25-2009
    Location
    Albuquerque NM
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Embedded Word size limits?

    Thanks again for all your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1