Excel 2007 Text Box

[Nick]

When I add a text box in to excel and protect the sheet but still allow a
user to edit it they can not add more line with enter. So who can they add
more lines?

 

[Bob Umlas, Excel MVP]

Right-click the border of the text box (while the workbook is unprotected),
select Size and Properties, on the Properties tab deselect Locked & Lock text.

 

[Bob Umlas, Excel MVP]

corection on my previous post -- no need to deselect Locked, only Lock text.

 

[Nick]

I try that and it still did not work

Right-click the border of the text box (while the workbook is unprotected),
select Size and Properties, on the Properties tab deselect Locked & Lock text.