Forum Discussion

Copper Contributor

Jun 26, 2019

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

Silver Contributor

Jun 26, 2019

Grosner

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
Copper Contributor
Jun 26, 2019
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.
- Haytham Amairah
  Silver Contributor
  Jun 26, 2019
  Grosner
  
  Ok, I confirm the issue!
  It seems like the grouping causes this weird bug!
  You can send feedback to the Excel Team about it.
  For now, the workaround is to forget the grouping!
  
  Regards
  - Grosner
    Copper Contributor
    Jun 26, 2019
    Haytham Amairah
    Thank you for confirming this issue.
    I will provide feedback to Microsoft.
    It would be nice if anyone has an actual workaround.
    
    Thanks!