Results 1 to 2 of 2

locking text boxes in Excel

This is a discussion on locking text boxes in Excel within the Excel Questions forums, part of the Question Forums category; Is there a way to lock a text box in Excel but still be able to add text. Just don't ...

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1

    Default

    Is there a way to lock a text box in Excel but still be able to add text. Just don't want the box to be moved from its position on worksheet.

    Thanks

  2. #2
    MrExcel MVP, Administrator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default

    Right-click on your text box and choose "Format Text Box."

    On the Protection tab, make sure "Locked" is checked. Uncheck "Lock Text."

    Then on the Properties tab, select "Don't move or size with cells," and click ok.

    Then you just need to protect your worksheet and you should be set!

    Hope this helps,
    Kristy

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com