G
Guest
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.
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.