Forum Discussion
Shapes get resized after rotating (if it crosses sheet window)
Hello friends, i wonder if someone can give me an advice First of all i want to mention that problem happens with me on all excels later then 2003 on all PCs i have searched almost every topic and ...
Hi Buba,
I don't know the answer, just played with your sample. In addition - the shape is resized if only the height is more than width and you rotate the shape on 45 degrees or more. Otherwise the shape is not resizing.
I guess there is no option, at least in UI, by which you may change such behaviour.
- shape gets resize in any case if it would cross sheet.
in excel 2003 this is solved very correctly, shape moves inside and then resizes so it still fits and rotatesNo in my case for Excel 2016
44 degree - not resized
45 degree - resized
Not sure about 2013, do not have access to it right now
- you are correct,same here
and it will be same in 2013 also and in 2007.
in any case i need 45 or more degree ,might there be any VBA that locks resize but not moving?
