I have both a text box and an active x text box at the bottom of my spreadsheet. I am trying to get one of them working and then I will delete the other one. I want to protect my sheet but also be able to write in a notes box at the bottom. The box needs to be able to have multiple lines.
If the sheet is not protected, the regular text box works exactly as wanted by expanding as you put more text in. If you protect it, the regular textbox does not expand as you hit enter.
An active x text box allows you to press enter for a new line but the text just scrolls up in the box so you can see the new line but it won't increase in size.