Skip to content

Latest commit

 

History

History
40 lines (24 loc) · 997 Bytes

Excel.Shape.LockAspectRatio.md

File metadata and controls

40 lines (24 loc) · 997 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Shape.LockAspectRatio property (Excel)
vbaxl10.chm636102
vbaxl10.chm636102
Excel.Shape.LockAspectRatio
1b517827-ebe0-a6ae-0fd7-fe3049eb6d04
05/14/2019
medium

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