Forum Discussion
Grosner
Jun 26, 2019Copper Contributor
Excel VBA Shape Rotate makes unwanted Move and Resize to Shape Group.
A shape group is getting resized after VBA rotation. The attached Excel 2016 / Office 365 workbook contains a worksheet with 2 sets of shapes: Triangle 1 and Circle 1 (Ungrouped) Triangle 2 an...
JKPieterse
Jun 26, 2019Silver Contributor
I'm unable to reproduce the issue, both shape combinations rotate the same and keep their sizes.
Grosner
Jun 26, 2019Copper Contributor
Ok, Thanks for trying. It is interesting you cannot duplicate the resize issue.
Are you using Excel 2016 / Office 365 with latest updates applied, as I am?
Additionally, be sure to enter a different value into Cell H4 and press enter.
You may need to do this several times in order to see the effect, because the resize and move occur in very small increments.