+ Reply to Thread
Results 1 to 3 of 3

Protect text box from formatting but not input???

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Protect text box from formatting but not input???


    Is it possible to protect an inserted text box from being moved, stretched, etc. while allowing data input into the cell/s?
    If so, any help is greatly appreciated. I'm using a 2003 version of excel.
    I've attached the sheet in question.
    The yellow text boxes are what I want to lock, yet still allow data input.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Protect text box from formatting but not input???

    Right click on the text box and choose Format Shape (this is what to do in 2010 version so may need adapting for 2003).
    In properties uncheck Lock Text.

    Make sure you then protect the worksheet so that this rule takes effect.
    Say thanks, click *

  3. #3
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Protect text box from formatting but not input???

    Thanks for the advice, but it isn't available in the 2003 version. I've attached a print screenshot of what my options are when I right click on the text box.
    Any other suggestions? I've also looked at my tool bar options and couldn't find 'format shape' also attached is the only format options I can find.
    Thanks in advance for any help.
    I'll keep trying.

    right click example 1.jpgFormat options.jpg

+ 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