How to select all ActiveX objects in an area using a mouse in Excel?
- by enderland
Because of this problem with ActiveX objects changing size, I am not grouping my ActiveX objects in my Excel worksheet. Grouping them causes my solution hack to not work which is quite annoying.
However, I often times want to be able to essentially use the mouse and select a region and then select all ActiveX objects contained in the region. This would also be useful for easily selecting objects to group them initially.
Basically:
Use mouse to select area
Automatically select all ActiveX components in region
I'm fine with a VBA solution if needed.
How can I do this?