Automatically size the textbox - no
You can of course do it with code.

you can protect the sheet to keep the user from making changes.

--
Regards,
Tom Ogilvy


"Phil H" wrote:

I have inserted textboxes in merged cell ranges as a way around Excel's cell
character count restrictions. There are ten worksheets with multiple
textboxes. Three questions:

1.) Is there a way to automatically size this textbox to the merged cell
range size?
2.) How could I keep the user from resizing or moving the textbox? They
should only be allowed to type text in it.
3.) Can/should this be done with code?

Without resolving issues 1 and 2, the worksheets will get pretty messy, as
there are about six of these textboxes in each worksheet.