Text box

[dpaton05]

I have an invoice spreadsheet that needs the ability to write notes at the bottom. I want to lock the spreadsheet but there are a few requirements I need with a text box:

• The main one is that I need to lock the sheet and keep writing in it
• I need the text box to expand as you write more lines
• I need the size of the text to not be resized when new lines are added.

How do I do this as with all the options I have been trying, there has been problems with it?


Thanks,
Dave

 

[Michael M]

Have you tried

1. When you protect the sheet, the protection dropdown has an "Edit Objects" checkbox....make sure you tick that box

2. Select shape>>rclick>>format shape>>TextBox>>tick the "Autofit" checkbox