locking text boxes in Excel

silentgliss · May 16th, 2002, 11:35 AM

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

Von Pookie · May 16th, 2002, 11:42 AM

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,

May 16th, 2002, 11:42 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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 How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 11:35 AM	#1
silentgliss New Member Join Date: May 2002 Posts: 1	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