| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Text Box
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Text Box
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. "Nick" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Text Box
I try that and it still did not work
"Bob Umlas, Excel MVP" wrote: 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. "Nick" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Text Box
corection on my previous post -- no need to deselect Locked, only Lock text.
"Nick" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Speech on Excel 2007 | Excel Worksheet Functions | |||
| text to speech in Excel 2007 | Setting up and Configuration of Excel | |||
| Excel 2007 macro text | New Users to Excel | |||
| text to voice in EXCEL 2007 | New Users to Excel | |||
| Excel 2007 Text Box Display and Printing | Excel Discussion (Misc queries) | |||
Hybrid Mode
