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...
Haytham Amairah
Jun 26, 2019Silver Contributor
Hi,
I've tried to rotate them, but they both rotate correctly as the screenshot below!
I think there is a bug in your current version of Office, so please make sure you have the latest version of Office 365.
Regards
Grosner
Jun 26, 2019Copper Contributor
I am fully updated.
If you look closely at the result image, you will see the image on the right is slightly larger. I am guessing you only entered a value into cell H4 one time. If you enter any value several more times, pressing enter after each entry, I think you will see the changes more clearly.
Also, right click and select size and properties. This should show the same value for height and width for the grouped object. If it does not, then you have replicated my situation.