Skip to content

Latest commit

 

History

History
37 lines (24 loc) · 1019 Bytes

Excel.ShapeRange.LockAspectRatio.md

File metadata and controls

37 lines (24 loc) · 1019 Bytes
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ShapeRange.LockAspectRatio property (Excel)
vbaxl10.chm640109
vbaxl10.chm640109
Excel.ShapeRange.LockAspectRatio
58b33bc9-de5c-1fb2-7369-7f4f8dedde58
05/14/2019
medium

ShapeRange.LockAspectRatio property (Excel)

True if the specified shape retains its original proportions when you resize it. False if you can change the height and width of the shape independently of one another when you resize it. Read/write MsoTriState.

Syntax

expression.LockAspectRatio

expression A variable that represents a ShapeRange object.

Example

This example adds a cube to myDocument. The cube can be moved and resized, but not reproportioned.

Set myDocument = Worksheets(1) 
myDocument.Shapes.AddShape(msoShapeCube, _ 
    50, 50, 100, 200).LockAspectRatio = msoTrue

[!includeSupport and feedback]