Hi all,
Is there any way to turn off the ability to select a Text Box? Just a regular Text Box object in a worksheet (not in a form, etc.). It would be similar to how the border of a Group Box can be turned off via the code below and cannot be selected until it is turned back on. Note that I still need the text to be visible. Also, the Text Boxes will be snapped to the size of various cells, so if those cells change in size due to row or column adjustments, I need the Text Boxes to adjust accordingly, like they normally do.
Thanks!
Is there any way to turn off the ability to select a Text Box? Just a regular Text Box object in a worksheet (not in a form, etc.). It would be similar to how the border of a Group Box can be turned off via the code below and cannot be selected until it is turned back on. Note that I still need the text to be visible. Also, the Text Boxes will be snapped to the size of various cells, so if those cells change in size due to row or column adjustments, I need the Text Boxes to adjust accordingly, like they normally do.
VBA Code:
activesheet.groupboxes.visible = false
Thanks!