This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Lock Aspect ratio for pictures in Excel does not seem to be working. Having ticked-on (enabled) "Lock aspect ratio" I am still able to increase or decrease the picture height without the width following.
The same goes for pictures imported and formatted using VBA. It seems to be a new issue. I'm running a piece of VBA code which imports, handles and resizes pictures which is dependent on Lock aspect ratio to be working (As width is being changed assuming the height will follow due to a locked aspect ratio). I have not had this issue with the exact same VBA code about 1-2 months ago.
I.e. I'm having the issue both when handling pictures manaully and using VBA code.
Any suggested work-arounds?
Is this a bug in a recent Office-update?
I'm using Microsoft Office 365 ProPlus
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
what Locking aspect ratio does is if you increase the size of the image height, it also increases the width relative to the ratio of the height. What its for is so that the image don't look narrow or fat when one of the size dimension changes. It does not mean the image cannot be resized.
The same goes for pictures imported and formatted using VBA. It seems to be a new issue. I'm running a piece of VBA code which imports, handles and resizes pictures which is dependent on Lock aspect ratio to be working (As width is being changed assuming the height will follow due to a locked aspect ratio). I have not had this issue with the exact same VBA code about 1-2 months ago.
Please try my code from this post:
What happens?
Andreas.