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 ...
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.
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,